Results 1 to 6 of 6
  1. #1
    bbrazeau is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    101

    Datepicker displays as text box on form portion of split form


    I have a form that is a split form with the datasheet portion on the bottom and the form portion on the top. The top portion displays the date field as a simple textbox control, but the data sheet portion displays the field as a date picker control. Is this normal? I wish that the controls on the form portion would display as date picker controls as well. The fields in the underlying table are date type (Short) and the Show as date picker option is set to For Dates on the form. Does anyone know why this doesn't work? Thank You.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    if the text box holds a date, you will get a date picker. (tho sometimes its confused)
    You can turn it off if needed, SHOW DATE PICKER property.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Cannot replicate the issue. If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    bbrazeau is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    101

    datepicker

    Here is the database minus info.
    The issue is in the Jobs Form
    Attached Files Attached Files

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I get the date picker icon when I enter the textbox then click on icon and the date picker opens. I don't like using the date picker because I design forms to minimize switching between keyboard and mouse. I disable date picker and use an input mask. Usually my forms allow data entry without ever leaving the keyboard.

    A few records would be helpful for testing, however, don't think I need to.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    bbrazeau is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    101
    So My Access install must be messed up because I only get the date picker icon if I click on the field in the datasheet portion of the form. It just seems odd that it would work in the datasheet portion of the form but not on the top portion. So it's finding the reference on one part of the form, but can't find it on the other??!!

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

Similar Threads

  1. Combo Box displays as text box on form
    By dwaterman in forum Forms
    Replies: 2
    Last Post: 03-26-2016, 02:39 PM
  2. Replies: 7
    Last Post: 01-21-2016, 08:59 PM
  3. Replies: 5
    Last Post: 07-25-2014, 02:57 PM
  4. Formatting split form datasheet portion
    By SpaceEd in forum Forms
    Replies: 5
    Last Post: 10-19-2011, 11:40 AM
  5. Datepicker set to short date: displays time?
    By sprovoyeur in forum Forms
    Replies: 3
    Last Post: 07-19-2011, 06:24 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