We have a field on a form, that is set to format Currency, and is using a field from a table that has Data Type of Currency. and it still appears as a number. any idea's?
Printable View
We have a field on a form, that is set to format Currency, and is using a field from a table that has Data Type of Currency. and it still appears as a number. any idea's?
It sounds like you're using Access and a data control. If so, issue a format statement to the fields after you do your edit/update methods. For some reason the data control loses the formatting once the table is updated. one of those things that ticks me off about data controls.