Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

CodeProject.FileFormat Property

Office 2007
Returns an AcFileFormat constant indicating the Microsoft Access version format of the specified project. Read-only.



expression   A variable that represents a CodeProject object.


Use the ConvertAccessProject method to convert an Access project from one version to another.


This example evaluates the current project and displays a message indicating to which version of Microsoft Access its file format corresponds.

Visual Basic for Applications
Dim strFormat As String

Select Case CurrentProject.FileFormat
    Case acFileFormatAccess2
        strFormat = "Microsoft Access 2"
    Case acFileFormatAccess95
        strFormat = "Microsoft Access 95"
    Case acFileFormatAccess97
        strFormat = "Microsoft Access 97"
    Case acFileFormatAccess2000
        strFormat = "Microsoft Access 2000"
    Case acFileFormatAccess2002
        strFormat = "Access 2002 - 2003"
    Case acFileFormatAccess12
        strFormat = "Microsoft Access 2007"
End Select

MsgBox "This is a " & strFormat & " project."

Community Additions

© 2015 Microsoft