Details section not appearing when viewed in Form View

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

markmarko - 15 Dec 2007 01:20 GMT

So I have this data entry form with controls linked to a number of tables. I
built it today, and up til recently worked fine.

Now, I'm having a problem where all the controls in the Details section
(when in Design View) fail to appear when viewed in Form View. My Header info
appears, just not the Detail section.

I didn't consciously change anything that would make a section not-visible.

Any tips?

Thanks!

Reply to this Message

Jeanette Cunningham - 15 Dec 2007 01:43 GMT

Hi Markmarko

This will happen in Access if there is no data to show in the form.
The way to check for this is to open the query the form is based on.
If the query returns no records, this is why the detail section of the form
goes blank.

Jeanette Cunningham

> So I have this data entry form with controls linked to a number of tables.
> I
[quoted text clipped - 11 lines]
>
> Thanks!

Reply to this Message

Linq Adams - 15 Dec 2007 04:00 GMT

Actually, this will happen in Access if there is no data to show in the form

***AND***

AllowAdditions is set to No!

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

markmarko - 17 Dec 2007 17:43 GMT

Thank you both for your replies...

The tip about checking the query helps... One of the tables linked is
causing a problem, though I haven't figured out why yet. If I remove it from
the query, the form details shows.

I think that's a very weird behavior. Even if there are no records to show,
I would think it would show the controls and labels. It made me think there
was a bug.

Reply to this Message