Change Group Name

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

Guest

Ive seen this on another thread but couldnt grasp it.

I have a simple report that puts each record in one of two groups, depending
if a tick box is true or false. Now, instead of my group titles being 'True'
and 'False', I want a proper description.

The first control is a text box with ControlSource set to the right field
but I understand I also need a seperate control (text box or label ??), but
thats about as far as I've got.

Thanks in advance
 
If I understand correctly, you have a yes/no field that you would like to
display as "Value A" when True/Yes and "Value B" when False/No. If so, try
an expression like:
=IIf([YesNoField] = True, "Value A", "Value B")
Make sure the name of the control is not also the name of a field.
 
Im sure i was trying that before... but its worked now. Thanks Duane

Duane Hookom said:
If I understand correctly, you have a yes/no field that you would like to
display as "Value A" when True/Yes and "Value B" when False/No. If so, try
an expression like:
=IIf([YesNoField] = True, "Value A", "Value B")
Make sure the name of the control is not also the name of a field.

--
Duane Hookom
MS Access MVP
--

Widemonk said:
Ive seen this on another thread but couldnt grasp it.

I have a simple report that puts each record in one of two groups,
depending
if a tick box is true or false. Now, instead of my group titles being
'True'
and 'False', I want a proper description.

The first control is a text box with ControlSource set to the right field
but I understand I also need a seperate control (text box or label ??),
but
thats about as far as I've got.

Thanks in advance
Click to expand...
Click to expand...
 
Back
Top