return as null value if empty string

[jasn_78]

Guys I have a query that when it gets to a certain field with a blank/empty string displays the previous field, is there a way to say if the string is empty show as a null value isntead?

I dont understand why it is doing this either so if some1 can explain it to me would be great

btw the db cant be changed as I am not the one who actually writes the db or the program that updates it I am just writing some extra reports from it so even if i want to i cant change data structure

 

[apr pillai]

I am not sure I understood you correctly!

Try changing the Format Property of the Control/Field to @;"Null" where you want to display Null when the field /control value is Null/Empty String.

 

[jasn_78]

apr pillai: thats exactly what i mean but when i do that in the following
ADDR2: Format([ACMF_ADDRESS_2], @;"Null")

it says invalid syntax what do u mean i should be doing?