Text What I Expect

[Sash]

I have the following code in a report to print as a paragraph in my document.
Everything works fine, except HEIGHT consistently prints as 10260,
regardless whether the field is 6' or 5'4". I have the field set to text in
the table. When I place the field on the report, not as part of the
paragraph, it prints as 6' or 5'4 or whatever the user input.


=" Description of the individual is as follows: " & [RACE] & " " &
[SEX] & "; " & "; " & [HEIGHT] & "; " & [WEIGHT] & " lbs.; " & [HAIR] & "
hair" & " and approximately " & [AGE] & " years old."

 

[Klatuu]

Because it is enclosed in brackets, it should not be a problem, but HEIGHT is
an Access reserved word and should not be used as a name. I can't promise
that is the problem, but I would experiment with changing the name of the
field.

 

[Sash]

Perfect and my face is RED! Thank you!

Because it is enclosed in brackets, it should not be a problem, but HEIGHT is
an Access reserved word and should not be used as a name. I can't promise
that is the problem, but I would experiment with changing the name of the
field.
--
Dave Hargis, Microsoft Access MVP

I have the following code in a report to print as a paragraph in my document.
Everything works fine, except HEIGHT consistently prints as 10260,
regardless whether the field is 6' or 5'4". I have the field set to text in
the table. When I place the field on the report, not as part of the
paragraph, it prints as 6' or 5'4 or whatever the user input.


=" Description of the individual is as follows: " & [RACE] & " " &
[SEX] & "; " & "; " & [HEIGHT] & "; " & [WEIGHT] & " lbs.; " & [HAIR] & "
hair" & " and approximately " & [AGE] & " years old."