Use Str() around the numeric field:
=Trim([chrDataAlways] & ("; "+Str([intDataSometimes])))

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Steve" wrote in message
...
Greetings:

Using the "+" to peform a "null propagation" as outlined in
http://office.microsoft.com/en-us/ac...494721033.aspx
by Sal Ricciardi does not seem to work when the data is numeric. Is there
a
work around for this?

For example:
=Trim([chrDataAlways] & ("; "+[chrDataSometimes]))
where chrDataSometimes is text data. This works!

=Trim([chrDataAlways] & ("; "+[intDataSometimes]))
where intDataSometimes is numeric data. This produces an error).

Thanks for any help.

--
Steve