If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Check Box On Condition
I have a field in my database that specifies the Road Classification.
Possible values include Freeway, Arterial, Collector or Local. I would like to display the data in my reports a series of four possible check boxes. Each check box would represent one of the possible values for the Road Classification field. Essentially if the value of Road Class is Freeway, then the freeway check box would be set to enabled. Similarly the check boxes would become enabled and disabled for the other three possible values as well. Any help would be appreciated. |
#2
|
|||
|
|||
Check Box On Condition
If I understand correctly, you could use check boxes with control sources like:
=[RoadClassification]="Freeway" =[RoadClassification]="Arterial" etc -- Duane Hookom Microsoft Access MVP "Mike" wrote: I have a field in my database that specifies the Road Classification. Possible values include Freeway, Arterial, Collector or Local. I would like to display the data in my reports a series of four possible check boxes. Each check box would represent one of the possible values for the Road Classification field. Essentially if the value of Road Class is Freeway, then the freeway check box would be set to enabled. Similarly the check boxes would become enabled and disabled for the other three possible values as well. Any help would be appreciated. |
Thread Tools | |
Display Modes | |
|
|