Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008

    Red face fields not showing up in Form view


    I have just created a new employee database and am in the process of creating forms to make it easier to enter data. I have adding fields from various tables in Datasheet view; however, when I switch to form view my fields do not show up????

    I've tried doing this manually and using the wizard and each way turns out the same. I should note I am using Access 2007.

    Any advice would be appreciated.

    Thank you

  2. #2
    Join Date
    Jul 2008
    Alexandria, Egypt.
    check the relationships between tables

  3. #3
    maryannking is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    I had a similar problem that when I switched to form view all that I could view was the header - after searching found that the actual bar separating the header from the details with the downward arrow and the word details on it was set to visible "no" - changed it to yes and doing great!

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    Quote Originally Posted by eroy View Post
    ...adding fields from various tables in Datasheet view
    is not as easy as you make it sound. Unless you have defined the relationships and are using a query with joins, you are limited to one table to a form.

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

Similar Threads

  1. Form View
    By Olie in forum Forms
    Replies: 1
    Last Post: 08-03-2008, 11:28 PM
  2. Form - Datasheet View
    By kalove in forum Forms
    Replies: 0
    Last Post: 06-20-2007, 11:29 AM
  3. Txt box on form showing 'Balance'
    By wasim_sono in forum Programming
    Replies: 1
    Last Post: 04-25-2006, 05:58 AM
  4. Data Not Showing in Reports
    By Delin in forum Reports
    Replies: 1
    Last Post: 01-26-2006, 08:53 PM
  5. Null Values not showing up in a Query
    By Valli in forum Queries
    Replies: 0
    Last Post: 01-04-2006, 03:53 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