FORMAT DECIMALS IN A MESSAGE BOX

[HRAHIMI]

How can I format a field in a message box?? I need to format the decimal places.
Thanks!

 

[JeremyNYC]

use the format command.

If you want a more specific answer, give us a more specific question. =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[HRAHIMI]

OK I have the following line in my code:
MsgBox ("WARNING, there is a balance of $" & [Forms]![frmdomesticbal]![Text25] & ". &quot

Using the format command how can I format the decimal places.

Thanks!

 

[kraxmo]

Try using the format() function.

Example: (in the immediate window [Ctrl-G])

msgbox "Approx. PI value = 22/7" & vbcrlf & "RAW VALUE: " & 22/7 & vbcrlf & "5 DIGITS: " & format(22/7, "0.00000&quot Jim Kraxberger
Spinning gold into straw...