Input mask for height

I want to have a table with imperial heights stored (eg 5'10") but when I
create my inpout mask with 9'##" ( 9"' "##"") it just displays as 5'10. Is
there any way to have the inches symbol displayed as well?

Use two separate fields to hold the value for Feet and Inches.

You can print them on a report as:
=[Feet] & "' " & [Inches] & """"

Alternativley, use a single field to store the value in inches. You can then
display it on a report as:
=([Inches] \ 12) & "' " & ([Inches] Mod 12) & """"

Either way, you are able to perform any calculations you need (such as
calculating average height, or height-to-weight ratios)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alan UK" wrote in message
...
I want to have a table with imperial heights stored (eg 5'10") but when I
create my inpout mask with 9'##" ( 9"' "##"") it just displays as 5'10. Is
there any way to have the inches symbol displayed as well?