PDA

View Full Version : Checking for text in a field


Maria Tt
04-17-01, 04: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?

GS
04-17-01, 10:54
Look at the Trim function.

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


Glenn Schwandt