display format for numeric data in form view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on a very basic database design for entering data from a survey.
I am used to working with numeric data in the analysis stage. How do I define
a field as numeric and show the display on the form formatted as text? For
example, one question is: Are you a boy or girl? I want to a drop-down box to
display 'boy' and 'girl' (as its shown on the survey) where 1 = boy and 2 =
girl. Can I do this in Access (this is my first time creating a database so
I've been relying on the help feature but I really need a tutorial!). thanks
for any help you can offer!
 
I'm working on a very basic database design for entering data from a survey.
I am used to working with numeric data in the analysis stage. How do I define
a field as numeric and show the display on the form formatted as text? For
example, one question is: Are you a boy or girl? I want to a drop-down box to
display 'boy' and 'girl' (as its shown on the survey) where 1 = boy and 2 =
girl. Can I do this in Access (this is my first time creating a database so
I've been relying on the help feature but I really need a tutorial!). thanks
for any help you can offer!
Click to expand...

Add a combo box to your form.
Set it's RowSourceType property to Value List.
Set it's RowSource to
1,"boy",2,"Girl"
It's Bound Column to 1
Set it's Control Source to the field in the table.
Set it's AutoExpand property to Yes.
Set it's Column count property to 2
It's Column Width property to
0";1"

When entering data, only 'Boy" or "Girls" will show, however upon
selection, the table will store either 1 or 2.
 
Back
Top