Results 1 to 6 of 6
  1. #1
    Iain is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Location
    Aberdeenshire, Scotland
    Posts
    42

    Text Box Properties - Format property for date & time

    How do you get the down arrow of the format property for a text box, to display the display options for the date and time?

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    In the Property Pane for the Control, simply Click into the Format Property box and the arrow will magically appear!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Iain is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Location
    Aberdeenshire, Scotland
    Posts
    42
    Thanks, but it's not the down arrow I'm trying to display, it's the list of options when the down arrow is clicked.

    When I click on the down arrow, there is just an empty window with no date or time format options from which to choose.

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by Iain View Post
    ...When I click on the down arrow, there is just an empty window with no date or time format options from which to choose.
    If you're saying that no Formats of any type appear in the dropdown box, that would indicate that the Control is Bound to a Field that is defined as either a Text Field or a Memo Field.

    For Date/Time Formats to appear, the Control Source must be set to Date/Time Field or the Control must be Unbound.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Iain is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Location
    Aberdeenshire, Scotland
    Posts
    42
    Ok. That explains it nicely.

    Thank you for your help.

  6. #6
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Glad we could help!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Setting Custom Field Format Property Problem
    By Weelmaa in forum Programming
    Replies: 2
    Last Post: 02-25-2012, 05:33 AM
  2. tRNASFER text FILEd INTO DATE FORMAT
    By BorisGomel in forum Access
    Replies: 1
    Last Post: 01-05-2012, 10:08 AM
  3. Replies: 1
    Last Post: 08-07-2011, 07:58 AM
  4. Format in Property Sheet
    By KevinMCB in forum Reports
    Replies: 8
    Last Post: 01-19-2011, 12:00 PM
  5. Replies: 6
    Last Post: 01-04-2011, 05:43 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