changing a field

[Catherine]

I have just downloaded the contact Management data base for 2003, and I want
to change the field 'contact type' to 'how did you hear about us' and the
response which has a drop down field to just add text. How do I do this - I
am quit enew to Access and need to be taken through it step by step. Thank
you in advance

 

[Jeanette Cunningham]

Catherine,
--open the relationships window and delete the relationship between the
Contacts table and the Contact Types table
--open the contacts table in design view and scroll down to the field called
ContactTypeID
--change its name to HowFind
--change its Data Type to Text
--change its caption to How did you find us
--switch to datasheet view and save the table

Open the contacts form in design view
--select the combo for Contact type ID
--Format | Change To | Text Box
--on the property dialog | Data tab
--click on the drop down for Control Source and select HowFind from the list
--change the label from Contact Type to How did you find us
--save the form and open in normal view
--try adding new entries and see if it works OK

Jeanette Cunningham

 

[Wayne-I-M]

Hi Catherine

This "may" not be a good idea.

If you "really" don't want this information you could just open the form in
design view a press delete. This will not delete the data stored in the
table for previous entries but stop additional entires.

I would not do this (just as the redesign of the form would take a while)

If you open the table (contacts) in design view you can add a new field then
save. Then open the form in design and then select the control and change
the control source of the ContactTypeID control to the new field you have
just created. Don't forget to alter the control to a text box if that's what
you want. (use the format option then "change to")

Good luck