Ignoring blank fields

[Crackers]

I have a Text box on a Form that copies data entered into other Text boxes on the same form.
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.

 

[RuralGuy]

How do you currently achieve the copying?

 

[carash77ash]

How are you copying data from fields. i.e vba or expression.

You need to put more information in the forum.

Ash

 

[carash77ash]

Sorry Ruralguy

i started to type reply and had to leave computer. Should have refreshed screen to see if someonelse had already posted. Don't mean to leave same info twice.

Ash

 

[RuralGuy]

Not a problem carash77ash. Been there, done that.