concatenate if not null - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

concatenate if not null

Gregory Clancey

3 years ago

Sorry. . .
Haven't gotten to developer series yet.

Is there a VBA construct that will NOT concatenate if the "2nd" string is null?

I seem to recall once using something like "String0 + (", " & String1)"
(the syntax may be all wrong and this may not even be AccessVBA ???)

	Kevin Robertson @Reply 3 years ago
Do you mean Null Math?

	Gregory Clancey OP @Reply 3 years ago
Yes, Kevin! As usual you're spot on! Had I known the name "null math" I would have looked through Rick's THs. This works and, as a matter of fact, I've already included and tested it in my sample database. I'm sure I'd dredged up this memory from ancient days when we were sweating out the nightmare of the "The 640 K Barrier".

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View