Basic Form Question: Convert from List Box to Text Box

[UNC_Access]

Hi!

I used the form wizard to create a form which can be used for basic data entry.

My problem:

Some fields that the wizard created are not text fields (such as Last Name), and Access will not let me change to text box.

When I go into Design View and right click the list box --> Change To -->

Text Box is greyed out (I cannot select it). How can I fix this?

Thanks!

 

[UNC_Access]

Update: I sort of fixed it, but now the problem is that when I use the tab button to go from one box to the next, it skips the Last Name field until the very end.

How can I change this?

 

[edtab]

Text boxes have tab index properties that can be manually set.
Go to the text box and click on the "Other" tab.
One of the properties you can change is the Tab Index #.

If you change one, the other tab indexes would automatically
change as well to adjust the numbering for all the text boxes..

 

[gemma-the-husky]

right click the form header/or detail section (whichever you need) select tab order - then you can drag everything to the order you require