Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    36

    Unanswered: Changing the MS access Input mask via code

    ok ... i was wondering if it is possible to change the microsoft access input mask on a field through code

    does anyone no if and how this can be done?

    thanks in advance
    Kris Bennett

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    You can use the following code line to change the InputMask for a field on a current, open Form:

    Me.myFormTelephoneNumberField.InputMask = "(###) ###-####"

    Or on a different open Form (say named, Customers) with this line:

    Forms!Customers!myFormTelephoneNumberField.InputMask = "(###) ###-####"


  3. #3
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    36
    i meant on a table not form

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by i00
    i meant on a table not form
    Hi i00

    On a Table, simply click on the field of your choosing, then look at the FieldProperties window at the bottom. Where it says InputMask, just click on that and if that field type allows masks you can set it there.

    have a nice one,
    BUD

  5. #5
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    36
    grr i need 2 do it THROUGH CODE!!!!
    strange request ino - but thats how it is lol

  6. #6
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Unhappy

    Quote Originally Posted by i00
    grr i need 2 do it THROUGH CODE!!!!
    strange request ino - but thats how it is lol
    Sorry for my suggestion, I just go for the simplest way to get the end results....
    politely bowing out.......

    BUD

  7. #7
    Join Date
    Nov 2003
    Location
    Australia
    Posts
    36
    na - its cool just needs 2 be done via code

Posting Permissions

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