Error Joining text strings with no value

[ronnie]

I've created a text box to join text strings from 6 possible functions, but if any of them are left blank I receive an error. I was able to enter the following code to get the first function to work if blank (Blank Function is code " " to leave space blank)



=IIf(IsNull([TS Function1]), [BlankFunction], [TS Function1].Text)

How do I apply this to the following code to join all strings strings?

=([TS Function1]& ", "&[TS Function2]& ", " &[TS Function3]& ", " &[TS Function4]& ", "&[TS Function5]& ", "&[TS Function6])

[June7]

What do you mean joining functions? Those look like field names.

Why call a function or reference a field just to concatenate a space? There is a limit to number of characters allowed in a ControlSource expression.

Maybe you should call another function to assemble the 6 possible functions.

[ronnie]

Yes, my "functions" are fields that I'd like to join, but if any of them are blank I receive an error.
[BlankFunction] directs to a field with an entry" ", but if I enter this into the code as " " it does not work.

[June7]

Don't understand, concatenate a space same as concatenating any character. Or is your [BlankFunction] field really an empty string or Null?

What is the error?

A series of IIf's in the ControlSource expression can construct the string but it will be a long expression. Probably should build a custom function to accomplish.

[Missinglinq]

I'm confused as to exactly what you're trying to do, here, but the function usually employed to deal with Null ('blank') Fields is Nz(). For the example you gave it would be

=Nz([TS Function1], " ")

BTW, in Access, you can only refer the Text Property when the Control in question actually has the Focus, which is why it is seldom used.

Linq ;0)>