Hide Single Row and Make Read Only

[jamesfranklin]

Hi,


If there are any option to make read only for single column in a table.

ID Name Country
324 M USA
768 A UK
079 F Canada


I want to Make 'ID' as uneditable column.


Thank u for time spending int his post

[June7]

Cannot do that in table. Textbox on form has properties Locked, Enabled, Visible. Set any or all appropriately.

[jamesfranklin]

HI june7,
Thank u for ur reply...

What My requirement is?
I'm having two type of user.

Admin and User

i have restrict Some columns from User.
for ex: 'ID' column show only for Admin and not for User.
Thank u..

[June7]

Have user login to db (or get their id from network login) and then retrieve their authorization category from users table. Use VBA code to set the textboxes on form as Visible or not Visible depending on authorization. Or open different forms for each user category.

You have a login interface in the db? Login functionality is frequent topic in forum.

[jamesfranklin]

Hi,

Thank u for ur reply..........i will try