Text Box formatting Access 2003

[cc]

Hi,

I have the following text box in a report. I have it formatted for standard
2 decimal places, but I'm getting many more decimal places displayed.

="Rent Due on " & GetOpeningDate() & ": " & [Rent]

How can I format the field [Rent]?

Thank you.

cc

 

[cc]

I was able to locate a response from an earlier post and it worked!! Thanks.

="Rent Due on " & GetOpeningDate() & ": " & Format([Rent],"Standard")

cc

 

[boblarson]

Just a quick FYI -

Formatting at table level doesn't carry over to reports and most of the time
formatting in queries doesn't either. It's always good to format "at the
last moment" to ensure you are getting what you want.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

I was able to locate a response from an earlier post and it worked!! Thanks.

="Rent Due on " & GetOpeningDate() & ": " & Format([Rent],"Standard")

cc

Hi,

I have the following text box in a report. I have it formatted for standard
2 decimal places, but I'm getting many more decimal places displayed.

="Rent Due on " & GetOpeningDate() & ": " & [Rent]

How can I format the field [Rent]?

Thank you.

cc