Nulls and conditional text

jamesmacklin · Newbie Joined: 15 Nov 2004 Posts: 2

Hello All,

I am trying to create a label template which gets data from a Microsoft Access table. I need to use a considerable amount of logic to produce the appropriate text on the label. I am having difficulty using the Conditional Text feature when evaluating if a database field is Null (or 0 string length). It seems very simple (<field> != "" then X else Y). Unfortunately, I only get a true (1) value whether the field is populated or not. Is this an Access problem dealing with Nulls and can I get around this? Is there other logic that I could use to evaluate if a field is populated?

Any help would be very appreciated.

James

JohnV · Posted: Mon Nov 15, 2004 7:08 pm Post subject:

You will get this result if you are actually using the “<” & “>” to surround your field name. Try FIELDNAME != “”.

If that's not the problem then in a new doc try using your logic on fields from OO's built int Bibliography (a dBase file). If that works then I'd think the problem has to do with how Access handles empty fields. You might try FIELDNAME NEQ NULL or “NULL”. That's a SWAG but may work. (BTW, I don't have a problem with this using the Bibliography using actual text for your X & Y.)

I don't use Access so I can't help from practical experience but I suspect plenty of others can.