Format$ Is not a Recongnized built in functon name

[mrdagz]

Hi,
I have a mdb file that talks to a SQL DB that contains a set of reports, this run slow I am assuming this is because it runs though an ODBC link.

So I tried to create a ADP that connects directly to the SQL DB this works much faster but behind some of the reports I have VBA code and it does not seem to like some of the standard VBA functions like Format any one know of a way I can get this to work ?

 

[dhookom]

I would use Format() rather than Format$(). Have you attempted to compile your code? Have you checked for missing references.

Duane
Hook'D on Access
MS Access MVP

 

[mrdagz]

turns out the Fromat in the VBA code was not the one it was complaining about, it was in a select string behind a control on the report. this needed to the T-SQL syntax not access syntax.