Removing look-up from datasheet 1

[Helen267]

This may be an obvious question, but I'm new to Access, and I've searched this archive, and MS Access help, and can't find the answer!

I've been asked to "tidy-up" a database, and one of the tables has had look-ups created for a number of fields. I want to remove these, to get a "clean" set of data, so I can rebuild the relationships.

Can anyone tell me how to change the lookup combo box into a simple text field?

Thanks!

 

[LittleSmudge]

You can change a combo box control into a Text box control by :-

Open Form in Design View
Select combo box control
Click on the Format Menu
Pick Change To >
And then select text box


HOWEVER, I don't think that is what you need in this case.

What you need to do is to get rid of the "LookUp Field" setting in the TABLE Design.

To do this:-
Open the underlying table in Design View
Select the offenting row in the table view ( Field )
At the bottom of the screen select the LookUp tab and Blank out the RowSource property
Then set the Display control property to Text Box
Save and close
Repeat for every Foreign Key field that you can find that has a LookUp Field attached.


'ope-that-'elps.


G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[Helen267]

Thanks, that's exactly what I needed! I missed the look-up tab at the bottom of the design screen, but I knew there must be some easy answer!