Input mask for height

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan UK - 25 Apr 2005 10:59 GMT

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?

Reply to this Message

Allen Browne - 25 Apr 2005 12:25 GMT

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)

Signature

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.

>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?

Reply to this Message