Ignoring Blank fields (explained better?!)

[Crackers]

I have a Text box on a Form that copies data entered into other Text boxes on the same form.
I have used the formula =[Text2] &" "& [Combo26] etc in the main text box that I want all the information in.
Sometimes there may be the odd text box that does not have any data in it.
Is there anyway that I can put in code so that the blank text boxes are not copied into the main text box i.e. Only the populated text boxes are to be copied.
Thankyou for any assistance that you can provide.

 

[Newman]

Maybe this can help...
It wasn't use as you do, but the way it takes each fields that aren't null is the same anyway.
Hoping that it helps you get on the right way.