Need help with text box field containing numbers

[lakefun]

I'm in the process of designing a report and I need a text box that will concatenate a number field from my source table with text (ex. "Over 14,456 people dined at Chili's last week&quot. The problem is that I need the number to print with the comma and all I can get is 14456. Any ideas?

Thanks!

 

[JoeMiller]

Run a format command combine with the concatenation like this:

=Format([MyNumberField],"#,###&quot & " people dined at Chili's last week"

HTH Joe Miller
joe.miller@flotech.net

 

[lakefun]

When I added the code to the Control Source field and opened the report, I get a prompt asking me for "Format". What did I do wrong?

 

[JoeMiller]

It sounds like you've got some bad references. Go into a code window (ALT+F11) and click Tools-->References. Look for MISSING: and replace the file that is missing.

Joe Miller
joe.miller@flotech.net

 

[lakefun]

I checked and nothing was missing but I do remember that I hadn't been able to use the "Trim" function today.

 

[lakefun]

I ran the compact and repair utilities and now everything seems to be working correctly. Thank you!!