Hiding fields on form

[PaulJR]

Hi,

I have a Form that is filled in by various people. Once filled in, they hit a submit button that stores all the contents of the form to a table....fine.

I have some fields on the form that I would like hidden from view, such as Windows Login ID, date etc that must be saved to the table however they are of no use to the user who is inputing data only. I realise I can use the colour settings to hide them, but I wondered if there is a smarter way I can drop these fields from the form and still have them saved to the table.

Can anyone give me any pointers?
Paul

 

[pbaldy]

If you're using single or continuous view, you can simply hide the controls in design view. With datasheet view, you have to code it on load, setting the ColumnHidden property IIRC.

 

[PaulJR]

Thank you - I found and switched off the visible attribute in design view.