Change value from Y to Yes

D

David Ewer

I have a database with a table linked to an external source. Several of the
fields contain yes or no answers represented by a Y or N, which I want to
show in a form as a tick box. Is it possible to convert the Y and N results
into something that I can use in a tick box?

Thanks

David
 
K

Ken Snell [MVP]

Use an expression similar to this as the control source of the checkbox (so
long as it's for display only):

=IIf([FieldName]="Y", True, False)
 
S

Steve Schapel

David,

As another option for the checkbox's Control Source...
=([FieldName]="Y")
;-)
 
D

David Ewer

Hi Ken

Thanks for the information. I tried your suggestion and it worked a treat.

Regards

David

Ken Snell said:
Use an expression similar to this as the control source of the checkbox (so
long as it's for display only):

=IIf([FieldName]="Y", True, False)

David Ewer said:
I have a database with a table linked to an external source. Several of the
fields contain yes or no answers represented by a Y or N, which I want to
show in a form as a tick box. Is it possible to convert the Y and N
results
into something that I can use in a tick box?

Thanks

David
Click to expand...
Click to expand...
 
D

David Ewer

Hi Steve

Thanks for the information, I'll bear it in mind.

Regards

David

Steve Schapel said:
David,

As another option for the checkbox's Control Source...
=([FieldName]="Y")
;-)

--
Steve Schapel, Microsoft Access MVP

Use an expression similar to this as the control source of the checkbox (so
long as it's for display only):

=IIf([FieldName]="Y", True, False)
Click to expand...
Click to expand...
 
Top