Hello,

I am using MS Access 2007, and i was wondering if it is possible to hide or unhide a column in table using code. I am creating a table using code and I want to have one column hidden, so I was wondering if that is possible.

Thanks,
Sam Davis

---

Answer from Richard Rost:

You really can't easily manipulate TABLES with VBA code. Then again, you shouldn't really have your end users working with TABLES in the first place.

Create a QUERY or a FORM that has just the fields that you want your user to see. Then, have them work with that… instead of your table.