Using the Format function

[Guest]

Hello,
Is there an online reference for using the Format function to convert
Single, Double, Currency and Integer type values to strings? The Access 97
help is not very helpful.
I'm particularly interested in converting floating point values to
strings using exponential notation. Anybody know how to do this?
Thanks,
Dave.

 

[Allen Browne]

In the Immediate window (Ctrl+G) or any code window, type
Format(
Move the cursor back into the word, and press F1.
The Access 97 help is quite good.

You will end up with something like:
? Format(2992.5, "Scientific")
or:
? Format(2992.5, "0.000E+00")

 

[Crystal]

Hi DeskJockey,

I agree with Allen, the 97 help is excellent ... you just
need the way to get there quickly...

pressing F1 on a keyword in the Debug window or in module
code is great

--- object browser ---
press F2 in a code window to View the Object Browser
(or View, Object Browser from the menu)

change the library to "VBA" (for instance, instead of <all
libraries>) and look at the classes (categories) of
functions -- click on a class and then click on a function
in the right pane. To get the help for that function, press F1

The VBA library is the most basic library and a great place
to start exploring.

to lookup properties and methods for different objects like
forms, tabledefs, etc, change the library to Access

for recordsets, the library is DAO

explore the different libraries you have to pick from and
see what is available in each

when you are in the Object Browser window, the library that
each function/class is a member of is shown in the lower
left corner of the window

the Object Browser is a GREAT way to learn

when you have an object selected, press F1 to get help.

on DAO: the Microsoft 2.5/3.51 Compatibility Library has
more built-in help than other DAO libraries I have used --
it is what was standard with Access 97.

from Tools, References...
you can select a library and then use the Object Browser to
see what it has in it...


Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com

 

[Guest]

Hi Cyrstal/Allen,
I agree that overall the 97 help is very good, but on this particular
subject I couldn't find what I wanted in 60 s, so got frustrated. I can
see now that if you hit the "See Also" help link for this function, all the
named formats are explained in glorious detail. I wasn't expecting the info
to be there.
Thanks,
Dave.

 

[Crystal]

Hi Dave,

you are welcome happy to help

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com