Results 1 to 3 of 3
  1. #1
    svcghost is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    38

    Input Mask characters stripped from table to table

    Hey guys,



    I have a field in one table that holds dates with the format of "mm/dd/yy HH:MM"

    I would like to know how to export the input mask characters along with the data, as opposed to just the data.

    Right now, I'm exporting the data as an XML file and the dates look like this: "062011 1930" - when I want it to look like this: "06/20/11 19:30"

    Any ideas?

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    an XML file isn't supposed to have any masking like that. the mask is on the output. that's where it should be coded to display. if you want the XML file to show the / and : then the data would have to hold the / :. Remember, an input mask doesnt really exist. Just a visual aid.

  3. #3
    svcghost is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    38
    Thanks Shabz. I put some format functions in my code to put in place those two symbols.

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

Similar Threads

  1. Replies: 4
    Last Post: 10-31-2010, 10:35 AM
  2. Input mask frustration (decimals)
    By Remster in forum Forms
    Replies: 2
    Last Post: 10-29-2010, 09:33 AM
  3. Phone Input Mask issue
    By Huddle in forum Forms
    Replies: 4
    Last Post: 08-13-2010, 03:02 PM
  4. day of week input mask
    By jacko311 in forum Programming
    Replies: 7
    Last Post: 11-15-2009, 12:56 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