EAK whats happened - grey only on form!

[evilcowstare via AccessMonster.com]

I have just added a text box and used the current date expression as its
source, but now when I click preview on the form it just shows grey and none
of my form, but it is still all there in design view. I clicked unto on the
date box but it is still just showing grey.
Eak what happened, anyone had this before?

 

[Rick Brandt]

I have just added a text box and used the current date expression as
its source, but now when I click preview on the form it just shows
grey and none of my form, but it is still all there in design view. I
clicked unto on the date box but it is still just showing grey.
Eak what happened, anyone had this before?

A form only prints when there is underlying data. A form bound to an empty
table/query will not show any controls when printed (at least not in the
detail section of the form).

 

[evilcowstare via AccessMonster.com]

But this isnt during printing, this is grey when I am in the working part of
the form, when it is not in design view. It has all the correct Source
controls in place :-/

 

[Rick Brandt]

But this isnt during printing, this is grey when I am in the working
part of the form, when it is not in design view. It has all the
correct Source controls in place :-/

That is also how a form looks in normal view when it has no existing records and
doesn't allow new ones. This is usually caused by binding the form to a query
that does not allow edits and when either the query or filter applied cause zero
records to be returned.

 

[evilcowstare via AccessMonster.com]

I managed to fix it, for reference....

I created a new form
Opened up the broken form
Selected ALL from broken form
Copied
Went back into new form
Pasted
Deleted old form
Saved new form as same name as old one
Opened it up
Changed forms record source to as it was
All done, works fine )