Disappearing Fields in a form

J

JohnC

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
 
J

John W. Vinson

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/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top