AnsweredAssumed Answered

Committing Field formatting to field/record

Question asked by ericjlindholm on Mar 23, 2011
Latest reply on Jun 7, 2011 by philmodjunk


Committing Field formatting to field/record


When I set a time field to be formatted like "10:30 AM", i can enter "10:30am" and it will display as "10:30 AM".  But when I click on that field/record or reference it in another calculation, it shows me what i initially typed("10:30am") and not the properly formatted version ("10:30 AM").  I want the record to commit with the formatting i assign it in the layout.

The same thing happens with money.  I set the formatting to display "$1,000", I can type in "1000" and it will display properly there but i cannot get the record/field to commit that way for proper displaying in other places.  

I get the feeling in need to make some sort of calculation attached to the table/field to make this work.

Thank you in advance for your time and help.