I have a customer who wants to print "1,000"
in a textbox . They are entering 1000 in the form . Can this be done in access 2000.Basically thay want to display the comma for anything above 999.

Try setting the Format to #,##0.00

I tried it and it still prints 1000 on the
report. I don't want the format in the table,
only on the report.

Is this a text or numeric field?

Text Field

Then why not change it to a numeric field?

Access will carry forward certain properties from table fields to form controls and report controls. HOWEVER, if you reset these properties at the table level, currently existing forms and reports are NOT changed.

If you want the format to apply to the control on the report, THAT is where you need to set the format.

I cannot put it in the form or the table because i have to print a barcode with that
information. I Do not wnat to put a "," in it.

I converted the field to numeric and it works the way i want it. Thank you.