Results 1 to 3 of 3
  1. #1
    Greenwalk is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    2

    Access Form with Subforms

    I have an Access form that has several memo fields on it, which are located above subforms on tab control. When one memo field is selected, it is set up as "GotFocus" so that the user can enter two or more paragraphs of text. The problem is when I click on one of the memo fields above the subforms, I cannot see the entire memo field because the subform is in the way. I tried using the Access feature "move to the front", but it does not work. What VBA code can I use to move the memo field to the front so I can view all the text. By the way, I also have the "LostFocus" set too. GotFocus/LostFocus both work fine, but not with the subform on the main form.

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    Welcome!

    Why would you have a subform and one or more controls for memo fields overlapping? Maybe explain a little better, add a screenshot, and/or upload enough so that we can see the problem.
    Last edited by jwhite; 04-07-2017 at 06:50 PM.

  3. #3
    Greenwalk is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2017
    Posts
    2
    That is the way the form is designed. An existing form created in Word was created that way. I am simply taking that Word document and putting it into Access. Everything is okay except for the overlapping. I just need to be able to click on the memo field and have it displayed in front of any other objects on the form.

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

Similar Threads

  1. Replies: 11
    Last Post: 05-13-2015, 11:10 PM
  2. Replies: 1
    Last Post: 12-30-2013, 05:56 PM
  3. About Access forms and subforms
    By sireesha in forum Access
    Replies: 1
    Last Post: 11-02-2012, 02:09 AM
  4. Access 2007, all subforms read-only
    By Merganser in forum Forms
    Replies: 1
    Last Post: 07-27-2011, 10:53 PM
  5. Subforms with Tabs in Access 2003
    By jaypoppin in forum Forms
    Replies: 3
    Last Post: 05-03-2011, 04:44 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