EAK whats happened - grey only on form!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

evilcowstare - 09 Jul 2007 20:56 GMT

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?

Reply to this Message

Rick Brandt - 09 Jul 2007 22:50 GMT

> 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).

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

evilcowstare - 09 Jul 2007 23:30 GMT

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 :-/

>> 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
[quoted text clipped - 5 lines]
>table/query will not show any controls when printed (at least not in the
>detail section of the form).

Reply to this Message

Rick Brandt - 10 Jul 2007 00:14 GMT

> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

evilcowstare - 10 Jul 2007 02:04 GMT

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 :o)

>> 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
[quoted text clipped - 4 lines]
>that does not allow edits and when either the query or filter applied cause zero
>records to be returned.

Reply to this Message