[AccessD] Can't hide controls in Datasheet view

Charlotte Foust cfoust at infostatsystems.com
Thu Jun 7 09:39:42 CDT 2007


If you open it in datasheet view, it has columns.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, June 06, 2007 6:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Can't hide controls in Datasheet view

No columns -- this is a regular form, using Datasheet as the Default
View.
There are no columns, just normal looking controls in Design View. 

Susan H. 

I think (am not certain) that what you need to do is this:

Open the form in datasheet mode.
Choose Hide Columns.
Save the form and close it immediately.
Re-open it and see if it does what you're expecting.
If it doesn't, open the form in design-mode, select the columns you want
to hide, Hide them, save the form, close the form and then re-open it.

If that doesn't work, run around the nearest church three times
clockwise and then try it again. :)

The former has worked for me. I haven't yet had to resort to the Church
thing, save once, and it worked.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list