Unanswered: Unbound Text Box Formats in Scientific Notation Upon Entry
I have an unbound text box on a form that is for the uses to enter in a 13-digit ISBN. The format property is set to "000-000-000-0000". When the user enters in the number and leaves the text box, it displays properly (by which I mean something like "123-456-789-0123"). But if the user needs to go back in to edit the field, when they enter the field is shows as scientific notation (i.e., "1.234567890123E+12"), which is a little confusing for the user.
As I've already mentioned I have the format property set. I also tried setting the decimal places property to 0 just to see if that would work, but no luck. Any ideas on how to keep it formatted as decimal on entry?
EDIT: I should probably mention that this is for Access 2007.