Currency with Infopath & Access

[learningaccess]

Hi. I am am just getting started with Infopath & Access. I am using
Infopath to make a reservation form and am storing the data in Access.
I have had no problems with this process except for with currency.

In Access I have certain fields designated to hold currency and have
set them at 2 decimal places. In Infopath this setting does not seem
to carry over. If the calculation yields $80.50, infopath shows 80.5.
It does not show the $ and always drops any zeros. Ironically, it is
stored correctly in Access as $80.50.

In Infopath Textbox properties, data type is "grayed" out and so I
can't change the settings there.

Any advice would be much appreciated, especially if it's written in
beginner language.

Thanks!

 

[Greg Collins]

Field formatting is available in the field properties dialog box. You can
set it to format with the "$" and two decimal places.

 

[learningaccess]

Greg,

Thanks for your tip. It definitely worked.

 

[Greg Collins]

Great! Glad to have helped!