Concatenate a string to a integer

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

In the control source of a textbox on a report, the following works fine:

="Investment: " & [Investment]

[Investment] field is of string data type.

However, when I try the same syntax with an integer data type, I get
"Error" displayed in the report's control.

Even if I try to convert to a string, like below, it still displays "error."

="Check No: " & str([CheckNo])

What am I doing wrong?
 
In the control source of a textbox on a report, the following works fine:

="Investment: " & [Investment]

[Investment] field is of string data type.

However, when I try the same syntax with an integer data type, I get
"Error" displayed in the report's control.

Even if I try to convert to a string, like below, it still displays "error."

="Check No: " & str([CheckNo])

What am I doing wrong?
Click to expand...

1) The function to convert a number to a string is Cstr() not str().

2) There should not be a problem concatenating a number value with
text. I suspect you're getting an error because the name of the
control is the same as the field name in the expression, [CheckNo].
Change the control name, perhaps to txtCheckNo. If you always use an
unbound control when writing a control source expression you wont have
this problem in the future.

Note: if [CheckNo] is never going to be used in any calculation, it
would probably be best to change it to a text datatype field anyway.
 
Back
Top