No Format Function in Class Modules

M

Murp

Can anyone explain to me why I would have access to the Format Function in
Standard Modules/the Expression Builder, but not Class Modules (both forms
and reports). It does not recognise it when I am typing the code, nor during
run-time.
 
A

Allen Browne

I'm guessing there is some kind of naming clash.

If so, you may be able to resolve it by specifying the Format() function of
the VBA library, e.g.:
Debug.Print VBA.Format(99, "000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Class Module returning ADODB recordset that can be assigned to forms or controls. 4
Open form relative to another form 1
Word doc keeps changing to ALL CAPS 0
Stephen Leban's Conditional Formatting 2
Form Runs Non-Existing Function 4
Excel 2003 - VBA to get a list of Module names in the project 4
Word 2016 - Difficulties Learning Style Creation/Application 0
Student count for Class Registration 1

Top