form problems

[He cries for help]

I am using access 2003. I placed all of my fields using design mode of my
form, when I close the form out and renter the form it is blank. I can select
design mode again and the fields return only to diappear again upon exit and
re-entry. I cannot figure out what is happening, I have spent a week on this
database and sure would hate to scrap it and start again.

 

[Jeff Boyce]

If your controls show in design view but not when the form opens normally,
one possibility is that there are no records for the form to display.

One way this could happen is if the query that feeds the form (you ARE using
a query rather than pointing directly at a table, right?!) is returning no
records.

Another way this could happen is if there are no records in the table.

Or maybe the form has controls placed on it but the form is not bound to ANY
set of data (not a table and not a query).

Any of those fit your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Beetle]

Depending on certain form properties and whether or not there is any data
in the forms recordsource, this may be normal. For example, if a forms
AllowAdditions property is set to No, and there is no data in the table or
query that is the forms recordsource, then the bound controls will not be
visible in form view because there is nothing to display.