I have a form with various fields the are visible in Design View
when I switch to Form View no fields are visible just the grey
background
Note -"visible" property is set to yes
and "Display when" property is set to always
I'm completely lost on this one

On Fri, 11 Mar 2011 05:54:59 -0800 (PST), JohnC <(E-Mail Removed)>
wrote:

>I have a form with various fields the are visible in Design View
>when I switch to Form View no fields are visible just the grey
>background
>Note -"visible" property is set to yes
>and "Display when" property is set to always
>I'm completely lost on this one

This will happen when two conditions are true:
1. The Form's Recordsource returns no records (so there are no existing
records to see)
2. The Form (or its Recordsource) is not updateable, so you can't see the
blank New Record either.

What's the Recordsource property of the form? Is it a Query? If so open it in
datasheet view; I'm guessing you'll see only the field headers, not even the *
blank record.

If you need help figuring out why it's not updateable post some more
information about the query, in particular its SQL text.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com