Presenting text value as numeric

[Len]

I have a data entry form where a bound field has a Text format in the
underlying table. This field should be displayed as numeric. For example, if
the value of the field in the table is 15000, it should be displayed as
15,000. Correspondently, if I enter in the form 250000, it should be
displayed as 250,000 and stored as 250000. I could not use data conversion
functions because this is a data entry field. Can this issue be resolved
through the input mask?

Thanks.

 

[Ofer]

Open the table in design view, change the Format Property of the field to
Standard

Or you can do the same in the text box in the form

 

[Len]

Thanks. The requirement is that the field format on the table side should be
Text . Changing to Standard format on the form side does not do the job.