Results 1 to 3 of 3
  1. #1
    Titleist is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011

    Entering Text in a Date (numeric) field possible?

    Greetings to all,

    I'm sort of a newbie so please forgive my ignorance...

    I have a form with 2 Date fields, a Start Date and a Completion Date. Each date field is setup with the Show Date Picker (little pop-up calendar) so users can simply click their desired dates.

    My issue is that I need the user's to also be able to enter Text in either date field. I need them to be able to enter "Previously Qualified" OR pick a Date.

    I've spent some time experimenting with the Text Box property sheet settings with no luck. Is this possible?



  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Then can't be a Date/Time datatype field. As a text datatype field, date would only be a string of characters. Access would not recognize as a data value.

    Textbox cannot be formatted for date and still allow text and you won't get the date picker without the date format.

    Bad design to mix data types in the same field.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Titleist is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    So the answer in NO. Thanks for the response.

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

Similar Threads

  1. Numeric vs. Text
    By Niki in forum Access
    Replies: 4
    Last Post: 06-10-2011, 01:28 AM
  2. Linked file text/numeric filter performance
    By awc109 in forum Import/Export Data
    Replies: 0
    Last Post: 04-19-2011, 11:02 AM
  3. Justify numeric text field
    By tpcervelo in forum Queries
    Replies: 2
    Last Post: 01-27-2011, 03:50 PM
  4. Split Numeric Data out of Irregular Text Field
    By nathanielban in forum Queries
    Replies: 6
    Last Post: 12-21-2010, 10:30 AM
  5. Bring in numeric text field to access from excel
    By Sck in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2010, 04:07 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 - Senior Forums