Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    1,191

    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.
    Last edited by nckdryr; 03-14-09 at 20:15.
    Me.Geek = True

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Do not use the format property of the control, use the inputmask property instead, like this:
    000\-000\-000\-0000;0;_
    Search in help for the meaning of the different parts of the input mask.

    Have a nice day!

  3. #3
    Join Date
    May 2005
    Posts
    1,191
    Heh, it's been so long since I've used an input mask I forgot all about 'em. This one actually worked for me:
    Code:
    000\-000\-000\-0000;;" "
    Me.Geek = True

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •