Database file extension

[mlai08]

I have created a mde file from a mdb database. I want to open a custom tool bar on the start up form only for the mdb file. Since the files have different extensions, can I set up a condition something like this in the start up form -
If current file extension = .mdb then
Me.ToolBar = "Custom Tool Bar"
End if

However, I can not figure out how to refer to the current file extension.

Any suggestion will be much appreciated.

 

[SOS]

You could use:

Select Case Left(currentproject.fullname,1)
   Case "b"
 
   Case "e"
 
End Select

 

[mlai08]

I believe you meant Case Right(....) but it works.

Thanks for your help.

 

[SOS]

Yeah, I meant right (my OTHER left).

 

[SOS]

So, the CORRECTED version (for anyone who might find this in the future) is:

Select Case [B][COLOR=red]Right[/COLOR][/B](CurrentProject.FullName,1)
   Case "b"
 
   Case "e"
 
End Select