Text What I Expect

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

Guest

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."
 
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.
 
Perfect and my face is RED! Thank you!

Klatuu said:
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


Sash said:
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."
Click to expand...
Click to expand...
 
Back
Top