Results 1 to 9 of 9
  1. #1
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110

    Field borders not displayed when creating a new record in Access 2010


    When this form is opened to a new record (DoCmd.OpenForm "frmOrderEntry", , , , acFormAdd) many of the text boxes do not display their border until I click in the text box itself. Even then some text boxes do not display their border. This is disconcerting to my users. Any ideas?
    Attached Files Attached Files
    Last edited by cebrower; 11-16-2018 at 03:34 PM.

  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,016
    I'm confused...none of your Controls appear to have borders...as if the Borders are set to Transparent...or maybe you're using a Theme that has this property set to Transparent.

    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
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    Take a look at the pdf attached to my original post. The first page shows the text boxes as they appear when the form opens to a new blank record - no borders. Scroll down to the second page and you will see what happens when I click in a text box. The border suddenly appears.
    Last edited by cebrower; 11-16-2018 at 03:35 PM.

  4. #4
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    Well, that is odd. Is this Form in Modal mode?

  5. #5
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    Yes, the form is in modal mode, but the problem persists even when it's not in modal mode. Also, when not in modal mode other open forms often come to the front even though this form is the last one opened. I will admit that this form has many fields and has a bunch of code behind the On Load event.

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    I would search the code behind the form_load event (as well as all the other events) for ".visible" and see what it reveals...

  7. #7
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    There are 6 or 8 text boxes, labels and command buttons that are visible or not visible depending on if the order is a quote, a confirmed order or a shipped order, but the issue remains even if I comment out that code. The issue only occurs when I'm creating a new record. If I open any existing record everything appears normal.

    Here's the sequence: User clicks a button on the main menu to start a new order. The customer list appears in DS view. User 2-clicks a customer name. A forms opens showing that customer's record in the Customer table in form view. User confirms that he selected the right customer. User clicks a button on that form labeled "Start Order". The program opens the order entry form to a new blank record and fills in some data related the the customer that was selected such as account type, sales tax status, billing address, etc.

  8. #8
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Try stuff. What happens if you just open the form from the navigation pane, then click new record navigation button at bottom? What happens if you comment out the code that "fills in some data related to the customer that was selected", and then open the form?
    Are any code lines "On Error Resume Next"?
    Is "Option Explicit" at the top of each code module?

  9. #9
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    I think I may have found the solution. The first line in the Load event was DoCmd.Maximize. I moved it so it's now the last line in that event and now everything works perfectly. I don't know why because I have many forms with Maximize as the first line in the Load event and they display just fine. Go figure!

    Thanks to all for your suggestions.

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

Similar Threads

  1. Replies: 1
    Last Post: 05-24-2013, 12:05 AM
  2. Replies: 1
    Last Post: 12-19-2012, 05:34 PM
  3. Field displayed as a record
    By DavidMack in forum Queries
    Replies: 6
    Last Post: 07-05-2012, 02:13 PM
  4. Creating a dynamic search box in Access 2010
    By bob500000 in forum Access
    Replies: 1
    Last Post: 11-24-2011, 02:27 PM
  5. Creating unique record from record and field data
    By arthurpenske in forum Access
    Replies: 3
    Last Post: 08-24-2011, 06:11 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