Access help

D

dabull4

I'm creating a databse that will store information for a survey. I've
established number values for each of the responses, but i'd like to have a
way to assign those number values to equal the actual text of the
questionarrie. example 1=poor or 2=spanish. how does one have hidden
function where you can view the responses as either the number value or the
text value? Any ideas?
Andrew
 
W

Wayne Morgan

Is this being displayed on a form or a report?

You would use code to change the Control Source of the textbox displaying
the value. For the number to be displayed, the Control Source would be the
name of the field. For the text to be displayed, you would make the textbox
a calculated textbox with an equation similar to the following in the
Control Source.

=Choose([FieldName], "Poor", "Spanish")
 
A

Arvin Meyer

Using a list box, you can hide any column or show them all. If you choose to
hide a column, you can show it's contents in a text box by setting its
control source to:

=Forms!FormName!ListBoxName.Column(ColumnNumber-1)

You can also use a combo box, but all the columns are only visible when you
drop it down.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top