Access Form

L

Lloyd

We have an Access database -- when you open the form in form view, it is
completely blank, but when you look at the design view, everything shows on
the screen.

We looked at the properties and it does show the form as visible. Is there
anything else we should look at to see why the form is not showing correctly
in form view?

Thanks
 
D

Douglas J Steele

What's the Recordsource for the form? (Open the form in Design view and look
at the properties for the form)
 
R

Roger Carlson

If an Access form is based on a query that is non-updateable and if no
records are returned in that query, then when the form is opened, the
controls on the form will not be visible.

Open your form in Design View and look at the RecordSource property. Open
the Record Source query and see if it returns 1) no lines or 2) one blank
line (with an asterisk (*) in the row header). If it returns no line, then
the query is non-updateable.

How you correct this, depends upon your circumstances.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
T

TC

This normally occurs when the table or query to which the form is
bound, is empty (ie. has no records), and the form's AllowAdditions
property is False, meaning that the form is not permitted to display a
blank new record. Try chnging that property to True (if it is currently
False).

HTH,
TC
 
A

Allen Browne

The Detail section of a form will go completely blank if both:
a) There are no records to show, and
b) No new records can be added.

(a) can be caused by an empty table, a Filter or criteria, or setting the
form's Data Entry property to Yes.

(b) can be caused by a read-only query as the RecordSource, or setting the
form's AllowAdditions property to No.

There are other possible causes, such as permissions or read-only media.
 
Top