R
Ron Dyson
Hi Kirstie,
When a number is formated with [;"Y";"N"], (not the
brackets, just the text contained), A Y will be displayed
if the number is negative and an N if the number is zero.
In a Yes/No field in a table, Yes is represented by -1
and a No by zero.
You can make a field any size you want and set the font
size to fill it.
In the Click Event code:
Me!fieldname = Me!fieldname Xor -1
to flip 0 to -1 and -1 to 0.
If you don't want to display "Y" and "N" you can use a
WingDing font or something and pick another graphic.
If you need more help Email me and tell what Access
you're using.
Ron Dyson
When a number is formated with [;"Y";"N"], (not the
brackets, just the text contained), A Y will be displayed
if the number is negative and an N if the number is zero.
In a Yes/No field in a table, Yes is represented by -1
and a No by zero.
You can make a field any size you want and set the font
size to fill it.
In the Click Event code:
Me!fieldname = Me!fieldname Xor -1
to flip 0 to -1 and -1 to 0.
If you don't want to display "Y" and "N" you can use a
WingDing font or something and pick another graphic.
If you need more help Email me and tell what Access
you're using.
Ron Dyson