Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Make some fields read-only on a query

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Make some fields read-only on a query

Resolved · Medium Priority · Version 2000

Reply Mon 27 Oct 2008, 16:54Delegate Andrew said...

Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Make some fields read-only on a query

Is it possible to set some fields in a query as read-only, while still allowing editing of other fields?

For upcoming training course dates see: Pricing & availability

Reply Wed 29 Oct 2008, 21:41Delegate Mark said...

RE: make some fields read-only on a query

Hi Andrew,

If you create a form to display the queried information or if it is already in a form then go to design view, click into the text boxes for each field you wish to lock, go to properties (right click and select or press F4), then go to Data tab, change Locked from No to Yes.

Regards, Mark (delegate)

Reply Thu 30 Oct 2008, 09:40Delegate Andrew said...

RE: make some fields read-only on a query

Thanks, Mark, that's great.

Access articles

· An Essential Guide To Using The Northwind Database In Access 2010
· An Introduction To Queries In Access
· Discover How To Link An Excel Spreadsheet To An Access Database
· Access And Its Uses On The Web
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps

Please browse our web site to find out more about
access advanced courses and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips