Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo Box 2 part question

Status
Not open for further replies.

jeremy0028

Technical User
Oct 9, 2005
37
0
0
US
I have a combo box called gender using the wizard i used i will type the values i want. I used male, female. which stores the information into a table called patient info under a field called gender

How do you set the default property so it would be male evertime a user adds patient record into the database.

On a report instead of displaying Male Female how would u display an x instead.
 
You can set the default value in the properties of the combo box. It is on the Data tab. Depending on your users, you may find that you have to check fairly often that Ms, Mrs and Miss have not been left Male. Which leads me to another point - it can be useful to set the gender when the title is entered.
Regarding the report, I guess you mean a some sort of checkbox set up, however, checkboxes do not translate well to other programs, so perhaps you could include a textbox under each heading with a control source something like:
=Iif([Gender]="Female","X","")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top