4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Access 97 Form column width question
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
iwps
Junior WebHelper
Junior WebHelper


Joined: 04 Jan 2006
Posts: 1

PostPosted: Wed Jan 04, 2006 4:39 pm (11 years, 10 months ago) Reply with QuoteBack to Top

I'm using Access 97 to which I populate several forms with data. When the user clicks on a row in the form, I store the data from that table row, then close that form (returning the user back to the main screen).

Here's the problem: My table contains all of the information I need stored, including some data I want hidden from the user. In the past, I slid the next column over to hide the "secret" column(s) {essentially setting the width to zero}, but someone accidentally slid it back, and now everyone want's to know "What's that?".

If I set the field's width to zero on form load, at run time it's still there. If I set the forecolor to white (to hide the data), at run time it's still visible (font color black). Even if I change the width at design time, run time always reverts back to the width the user slide the column to.

Question: How can I hide the column data, data that I need Question
OfflineView User's ProfileFind all posts by iwpsSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.055068 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme