formula help need 1

[pgtek]

Hi
i have a field in my table definied as varchar DOB
like this 020203
i have some data that the field was not completed fill
like this 0202 missing the last 2 varchar

How can i create a formula that would check if the field is not completely fill blank all the other field and display a complet blank for this entry field?

Cheer

pg

 

[Reebo99]

Create a formula :

If len({field}) <> 6 then &quot;&quot; else {field}

replace italics with correct field name.

Hope this helps.

Reebo
Scotland (Sunny with a Smile)

 

[pgtek]

Hi
Thanks Reebo it works
man my mind went blank

thanks
pg