Concatenate fields

  • Thread starter Thread starter Neal
  • Start date Start date
N

Neal

Concatenate fields works only in the Query.
NewAddress: =[Address] & ", " & [City] & " " & [Region]
& " " & [PostalCode]

Not in a Form, or Report.
The control source for NewAddress is
NewAddress: =[Address] & ", " & [City] & " " & [Region]
& " " & [PostalCode]

What stupid thing am I missing?

Thanks

Neal
 
the control source should be = [Address] & ", " & [City] & " " & [Region] &
" " & [PostalCode]


for a form or report:
 
Thanks

That's what I'm using.
If you mean the = sign, I'm using it.
NewAddress: is the name of the text box.
The control source for NewAddress is
=[Address] & ", " & [City] & " " & [Region]

What stupid thing am I missing?

Thanks
Neal
-----Original Message-----
the control source should be = [Address] & ", " & [City] & " " & [Region] &
" " & [PostalCode]


for a form or report:
Concatenate fields works only in the Query.
NewAddress: =[Address] & ", " & [City] & " " & [Region]
& " " & [PostalCode]

Not in a Form, or Report.
The control source for NewAddress is
NewAddress: =[Address] & ", " & [City] & " " & [Region]
& " " & [PostalCode]

What stupid thing am I missing?

Thanks

Neal
Click to expand...


.
Click to expand...
 
Back
Top