Access 2003 Change (Edit?) Field Format on a Form from a Query
Posted on 2013-01-15
I am progressing with an application that returns data from a query and displays it on a form.
The data in one of the fields (called Report_Number) is displayed in the following format:
I have a function that takes that data and changes it to the following:
Bascially separating the 1st two numbers, followed by a "-" and then stripping out the rest of the leading zeros.
The query I built returns the data to a Form displayed as a datasheet.
I am trying to apply this function to it's field in the form but I don't see what Event choice is the correct one to use.
The closest I got it working is if I apply this function to an unbound text field, the 1st record has this field formated correctly, but the rest of the records have their own fields displaying the 1st records data.
97-123456 (the correct one)
Where do I apply this function to change the data?