Connecting Tech Pros Worldwide Forums | Help | Site Map

Controls not visible in Form View

BradHodge's Avatar
Expert
 
Join Date: Apr 2007
Location: Lubbock, Texas - U.S.A
Posts: 160
#1: Jun 11 '07
Greetings all.

I'm using Access 2003. I have a form that is not showing any of the controls in the Detail section when you switch to Form View. You can see and change the color of the Detail Background, but none of the controls can be seen.

I've checked both the Detail section and Controls' properties. All are set to Visible "Yes" and all are set to Display When "Always". Controls that are in the Header and Footer show up fine.

Never had this one happen before. Any thoughts?

Thanks,
Brad.

Expert
 
Join Date: Apr 2007
Posts: 192
#2: Jun 11 '07

re: Controls not visible in Form View


Quote:

Originally Posted by BradHodge

Greetings all.

I'm using Access 2003. I have a form that is not showing any of the controls in the Detail section when you switch to Form View. You can see and change the color of the Detail Background, but none of the controls can be seen.

I've checked both the Detail section and Controls' properties. All are set to Visible "Yes" and all are set to Display When "Always". Controls that are in the Header and Footer show up fine.

Never had this one happen before. Any thoughts?

Thanks,
Brad.

I have had this happen many times. If your form is not allowing new records to be added, and the query or table the form is based on is returning no records, then you dont get to see any of the controls.

This gets very arkward if you delete the last record in a set, and then the form wont show you the controls to add a new record back in.
BradHodge's Avatar
Expert
 
Join Date: Apr 2007
Location: Lubbock, Texas - U.S.A
Posts: 160
#3: Jun 11 '07

re: Controls not visible in Form View


So then... If I add records to the table that it is based on and ensure that the form is set to accept new records, then I should see the controls?

Brad.
Newbie
 
Join Date: Jun 2007
Posts: 28
#4: Jun 11 '07

re: Controls not visible in Form View


Quote:

Originally Posted by BradHodge

So then... If I add records to the table that it is based on and ensure that the form is set to accept new records, then I should see the controls?

Brad.

Yeah. That should do the trick, if you still have problems, I have some thoughts
on it, such as using isnull sets and requery. Tell us what happens.

shiznaw
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,730
#5: Jun 11 '07

re: Controls not visible in Form View


As shiznaw says, test it out and let us know what you find.
BradHodge's Avatar
Expert
 
Join Date: Apr 2007
Location: Lubbock, Texas - U.S.A
Posts: 160
#6: Jun 12 '07

re: Controls not visible in Form View


Thanks yet again all. Your suggestions worked great and all is well in Form-Land!

Brad.
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,730
#7: Jun 12 '07

re: Controls not visible in Form View


Excellent. Very pleased to hear it Brad :)
Reply