How to use and store a diamond or inverted delta symbol

I have a database where they need to select, store and view either a diamond
or inverted delta symbol to designate a certain item. Is there an easy way to
do this without inflating the database by using images? They are using Access
2003 saved to a 2000 format.

One approach:

If this is just a display issue, find a symbol font (ie, webdings,
wingdings, etc) that has the symbols you need, determine what the ASCII
equivalent for those symbols are, set validation rules to only allow those
characters and make sure that anywhere that field appears on reports, forms,
etc, it uses the symbol font.

In other words, you could store the alphanumeric value "under the hood" but
the users would only see the desired symbol.

--
HTH,
George


"Jen" wrote in message
...
I have a database where they need to select, store and view either a
diamond
or inverted delta symbol to designate a certain item. Is there an easy way
to
do this without inflating the database by using images? They are using
Access
2003 saved to a 2000 format.

Thanks, I guess I was overthinking it. It took a little to find one font with
both symbols but I believe it should do the trick.


"George Nicholson" wrote:

One approach:

If this is just a display issue, find a symbol font (ie, webdings,
wingdings, etc) that has the symbols you need, determine what the ASCII
equivalent for those symbols are, set validation rules to only allow those
characters and make sure that anywhere that field appears on reports, forms,
etc, it uses the symbol font.

In other words, you could store the alphanumeric value "under the hood" but
the users would only see the desired symbol.

--
HTH,
George


"Jen" wrote in message
...
I have a database where they need to select, store and view either a
diamond
or inverted delta symbol to designate a certain item. Is there an easy way
to
do this without inflating the database by using images? They are using
Access
2003 saved to a 2000 format.

On Dec 11, 5:58 pm, Jen wrote:
I have a database where they need to select, store and view either a diamond
or inverted delta symbol to designate a certain item. Is there an easy way to
do this without inflating the database by using images?

What about a text column of width 7 characters with a validation rule
to restrict its contents to either 'Diamond' or 'Delta'. You would
then handle mapping between these words and what is seen by the end
user in the front end form.

Jamie.

--