Change value from Y to Yes

[Guest]

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

 

[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)

 

[Steve Schapel]

David,

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

 

[Guest]

Hi Ken

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

Regards

David

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)

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

 

[Guest]

Hi Steve

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

Regards

David

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)