Checking for text in a field

#1 (**permalink**) 04-17-01, 03:32

Heyas,

Is their a function that checks if a field has text in it - I have some fields that have jut spaces - different amount eact time - and I want to filter these fields out..

Eg I have three different mailing address fields - if mail address 2 has only got spaces - I dont want to view that field...

Any suggestions?
Maria Ttoullounge
____________
Database Development Officer Computer Science & Engineering
How can I control my life, when I can't control my hair?

#2 (**permalink**) 04-17-01, 09:54

Look at the Trim function.

Code:

If (Trim (mail address 2) = "", "", mail address 2)

Glenn Schwandt

Internet Services

Web Development

Digital Marketing

Consumer Tech