How to use and store a diamond or inverted delta symbol

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

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.
 
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.
 
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?
Click to expand...

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.

--
 
Back
Top