Input mask for height

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top