Change numbers to text in a Form

  • Thread starter Thread starter sfdalmom
  • Start date Start date
S

sfdalmom

I have a database in which the Table has numbers that correlate to text. For
ease of input, I would like the Form to display the text that is associated
with the numbers in the Table. (The data entry person doesn't know that 1 =
pink; 2 = blue, etc). How do I do this without changing the numbers in the
table?
 
Use a combo box on your form that has source from table with two fields -
numbers & text.
SELECT ID, Color FROM YourTable ORDER BY Color;

Column Count - 2
Bound Column - 1
Column Widths - 0"; 1.25"
 
Hi Karl - Thanks for your reply, which was helpful. I haven't worked with
Access for 6 years, and have been "thrown" into this project! I'm still a
bit confused about how to create the source in the form. Can you break it
down in more detail for me? (pretend I'm a 3rd grader...). Here are the
"real" data.
I have a Table Field titled "Research Site." There are 5 research sites and
they are numbered 8, 9, 10, 11, and 12 in the table. In the form that others
will use to enter data, I want the form to display "Hospital," "Cancer
Center," "Sleep Institute," "Veteran's Hospital," and "Other."

So, can you explain how I need to set this field up in both the table (do I
need one or two fields?, how should I set up the "Lookup" box for this
field?, should I specify "Number" or "Text" for this field?). Also, can you
explain in more detail how I should set up the field in the Form?

I really appreciate your help!!

Beth
 
Your table should look like this –
[Research Site] --
SiteID Site
8 Hospital
9 Cancer Center
10 Sleep Institute
11 Veteran's Hospital
12 Other
The datatype of SiteID must match the field in the other table.

In the form where you will be displaying/selecting the site use a list box.
Use the list box wizard. Select [Research Site] as source table and the
fields. Select ascending for Site. Select ‘Store value in this field ____’
and select your field from the list. Fill in ‘Research Site’ as the label.

The properties for the list box to be like this –
Name - Research Site
Control Source - your table field where data is stored
Row Source - SELECT SiteID, Site FROM [Research Site] ORDER BY Site;
Column Count - 2
Column Heads - No
Column Widths - 0â€; 1.5â€
Bound Column - 1
 
Back
Top