Tab Stop

Dowsey1977

Board Regular
Joined
Apr 6, 2004
Messages
185
Is there anyway not to have a tab stop on a form.

I've set 'No' in the properties for every control, but it still shows one.

Many thanks,
Simon
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,452
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
Hi Simon
Unless I am reading your question wrong, I would have thought Access would need at least one tab stop so that it knows where to place the cursor on opening the form. Someone please correct me if I am wrong.
Andrew.
 

Dowsey1977

Board Regular
Joined
Apr 6, 2004
Messages
185
You are reading the question right, however, I want the form to be a view only form, so the records will actually be updated elsewhere, which is why I don't want the tab stop.
 

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,452
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
If you want the user to view the records and not be able to change anything, rather than disabling the tab stops, what you can do is change the "Enabled" property for each item on the form to "No" (or change the "locked" property for each item to "yes" - same effect except the enabled set to no will change the box colour to grey). You can find this under form design, select an item, click view -> properties -> data -> enabled -> no -> repeat for all items on the form (or data -> locked -> yes). The user will be able to see the records but can't change them. Tip : you can set the property for all fields at the same time using a multiple selection.

An alternative method involves setting three properties at the form level : select form -> view -> properties -> data -> set allow edits, allow deletions and allow additions to no. This way is probably easier.

HTH, Andrew. :)
 

Forum statistics

Threads
1,181,074
Messages
5,927,961
Members
436,580
Latest member
ajoshi76

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top