Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppres a Field when another field has Data in it.

Status
Not open for further replies.

bryan3473

MIS
Sep 25, 2003
21
US
Hi all,
I was wondering how to suppress a default description field that will always have data where there is a alternate longer description available on some of our items than the default one.

So on some items it’s like this

1111 default
1111111 extended description

but another part description might be

2222 default
but no extended description.

So whenever there is extended i want to supress default.
 
Format the field Default > Suppress > x + 2
and enter:
Code:
NOT(IsNull({ExtendedDescription}) OR {ExtendedDescription} = "")

-----------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium
 
Your sample makes it appear that the description field you want to suppress is one instance of the same field that provides the extended description. Is this the case? If so, what is the groupfield for which you want to see the description?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top