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.