Set format textbox to currency

[dmr]

I have a bound form (which is used to enter data) and want to format some textboxes as currency. I see that there is a "format" property for the textbox, but I can't figure out how to set it to currency.

Thank you!

 

[Rich]

Select Currency from the drop down box on Format options

 

[dmr]

Select Currency from the drop down box on Format options

The dropdown box doesn't contain any options.

 

[Rich]

Is the table field format set to Currency?

 

[dmr]

Is the table field format set to Currency?

Yes. It's still not there.

 

[Rich]

Is the form bound directly to the Table?

 

[dmr]

Is the form bound directly to the Table?

Yes. (The form is a tab on a form. The outer form is bound to a different table.)

 

[Rich]

Open the form on its own and see what happens then

 

[vbaInet]

Like Rich said, set the Currency on each of the textboxes you would like formatted as Currency.

Select the text box on the form, go to Format tab in the properties and under that you will find Format. Select Currency there.

 

[dmr]

Open the form on its own and see what happens then

There still are no options by the format property.

 

[vbaInet]

Did you see my post? Did you open the subform on its own, not inside the form as Rich said? Can you post a screenshot of what you're doing?

 

[SOS]

This is on a subform (since it is not part of the main form) on the tab, correct?

 

[SOS]

 

[dmr]

This is on a subform (since it is not part of the main form) on the tab, correct?

Yes, that is correct.

 

[dmr]

I do not get any of the options, even if I scroll down.

 

[Rich]

Copy the form on its own and save it with a new name, try it then

 

[SOS]

I do not get any of the options, even if I scroll down.

Can you post a screenshot of what you are seeing?

 

[dmr]

The problem was that the datatype for the field was a "bigInt". I changed it to "float" and now everything works.
Thank you!