Results 1 to 4 of 4
  1. #1
    luckasx is offline Novice
    Windows 8 Access 2003
    Join Date
    Nov 2013
    Posts
    13

    Mask each item

    Hello, I have a form with a field called "Document". I need to apply two different masks for this fiels. Is it possible? Thanks.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    You might try something like this....

    If Me.chkOption = -1 Then
    Me.txtField.InputMask = "000\-00\-0000;;_"
    Else
    Me.txtField.InputMask = "00000\-9999;;_"
    End If

  3. #3
    luckasx is offline Novice
    Windows 8 Access 2003
    Join Date
    Nov 2013
    Posts
    13
    Quote Originally Posted by ItsMe View Post
    You might try something like this....

    If Me.chkOption = -1 Then
    Me.txtField.InputMask = "000\-00\-0000;;_"
    Else
    Me.txtField.InputMask = "00000\-9999;;_"
    End If
    I did this, but when I apply the mask, all other 'documents' are masked with the same type from the last.
    I need mask each item of the field.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    I don't know what to say. If the data is not correct at the time of input then you will need to update the information. Perhaps an UPDATE query would help. Maybe you can add another column and store data of the other format/mask in the second column, switching back and forth between fields as needed.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Parent Item / Child Item Not Saving Correctly Together
    By Evilferret in forum Programming
    Replies: 6
    Last Post: 08-24-2012, 02:30 PM
  2. Replies: 7
    Last Post: 10-25-2011, 08:32 PM
  3. How to do this in a mask? helpppp
    By mar1kam in forum Access
    Replies: 1
    Last Post: 11-19-2010, 11:05 AM
  4. custom mask
    By RedGoneWILD in forum Reports
    Replies: 2
    Last Post: 08-04-2010, 03:23 PM
  5. Input mask
    By doobybug in forum Access
    Replies: 2
    Last Post: 06-17-2009, 09:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums