Hey everyone,

first off. thank you. all your questions and answers have been a huge help in me getting my bearings on this program. you all are awesome...

my question -

i have a field for 'total height' in inches. and i just want to make a field that will convert it to X'Y

for instance...... they input 68 into the inches field. and the next field will say 5'8

any advice would be greatly appreciated.

thanks again.

or instance...... they input 68 into the inches field. and the next field will say 5'8

Is not clear how 68 to 5'8. What formula you use?

NumToText( Int( height / 12 ) ) & "'" & NumToText( Mod( height / 12 ) )

The NumToText() functions are probably a bit superfluous, but I like to be thorough. The "'" is a single quote surrounded by double quotes. " ' "

Hi Vaughan,

I think you were misled by [color:"blue"]aaa version being 6, the original poster [color:"blue"]pensive is using v7. Your calculation was missing a comma behind the Height in the Mod Function

NumToText( Int( Height / 12 ) ) & "' " & NumToText(Mod(Height[color:"red"], 12)) & """"

For this to work for [color:"blue"]pensive I have modified it as follows:

GetAsText( Int( Height / 12 ) ) & "' " & GetAsText(Mod(Height; 12)) & """

HTH

Lee

you guys are amazing. thank you all for the help.

it worked perfectly.

pensive...

oh...so close. the only problem is it can't calculate a double digit for the second number.

ex. 60" = 5'0"

but if i put 71" = ?

because it can't write 5'11

or 5'10", 6'11" etc....

please if its not too much problem, can you straighten me out?

GetAsText( Int( height_in / 12 ) ) & "' " & GetAsText(Mod(height_in; 12)) & """

thanks again...

Make your field wider?

ummm...yeah. nevermind.

good call. thanks.