Results 1 to 4 of 4
  1. #1
    Danzig's Avatar
    Danzig is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Socal
    Posts
    29

    Imput Mask problem (TEXT)


    I need help. I have a field that I am trying to make a text field, but I dont know how to edit list & create a new imput mask for text. All I have to choose from is Numeric i.e. long date, medium time etc.

    Can anyone tell me what I am doing wrong?

  2. #2
    slave138's Avatar
    slave138 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    WI
    Posts
    233
    First, you shouldn't cross post your questions - the moderators tend to get a little pissy about it.

    I suggest you stop trying to format the field if you are using a text filter. Also, make sure the field in the table is the Text type. If you want to create a new mask use the record buttons at the bottom to create a new record and create away.

    If you get an error when trying to save the mask, write it down.

    If you need a screenshot, press your Print Screen key then open an image editor (even MSPaint will work) and paste. Try to save it as something other than a BMP.

  3. #3
    Danzig's Avatar
    Danzig is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Socal
    Posts
    29
    sorry man, Im brand new to this forum, and fairly new to access. How do I mark as solved? or does it do it automatically? Thanks again. I kept makeing masks, but they werent showing up because the format was set as number. I changed it to text, and all of the masks I was creating showed up.

    By the way is there a way to go & delete them off the list? or are those stuck like that? I try to keep it as clean as poss.

  4. #4
    slave138's Avatar
    slave138 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    WI
    Posts
    233
    Here's the guide to marking topics as solved:
    https://www.accessforums.net/forum-s...lved-1828.html

    Deleting masks is a little more complicated:
    1. Open your "ACWZUSR12.ACCDU" file
      • Mine is at C:\Documents and Settings\<username>\Application Data\Microsoft\Access
    2. Open the im_TblInputMask table
    3. Scroll to the bottom to find the newest entries
    4. Delete those you don't need anymore
    5. Be careful about deleting the preset masks - not sure how Access feels about losing those

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

Similar Threads

  1. update a form with user's imput
    By nianko in forum Forms
    Replies: 3
    Last Post: 08-25-2010, 08:52 AM
  2. custom mask
    By RedGoneWILD in forum Reports
    Replies: 2
    Last Post: 08-04-2010, 03:23 PM
  3. day of week input mask
    By jacko311 in forum Programming
    Replies: 7
    Last Post: 11-15-2009, 12:56 PM
  4. Input mask
    By doobybug in forum Access
    Replies: 2
    Last Post: 06-17-2009, 09:40 PM
  5. Issue with conditional imput
    By Estyl in forum Forms
    Replies: 2
    Last Post: 02-19-2008, 10:42 AM

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