Control Source is Null

[CementCarver]

I have a control source field called "License" where I display a license number but I concatenate a letter in the front and an indication of the year at the end. For example: ="SM" & [SMLicence] & "-13"



But there are records where the License value is null. So in the field displaying this data, there a "SM-13" being displayed. This is very misleading, so I'd like to find out if the value is null, to not display anything.

How can I display a blank field if the value is null?

CementCarver

[rzw0wr]

You might try in you control source,
Iif([SMLicence] = Null ,"", "SM" & [SMLicence] & " -13")

That way nothing is stored in your table if you do not have a License number.

Dale

[CementCarver]

Thanks Dale,

I'll give that a try......CC

[CementCarver]

Iif([SMLicence] = Null ,"", "SM" & [SMLicence] & " -13") didn't work. The "SM" and the "-13" are still being displayed.

Any other suggestions.....? CC

[rzw0wr]

Where are you concatenating the text?
A form, table, query?

Dale

[CementCarver]

In a form. Here's the correct line I'm trying now.... =IIf([SMLicence]=Null,"","SM" & [SMLicence] & " -13")

CC

[rzw0wr]

try,
Iif(isnull([SMLicence]) ,"", "SM" & [SMLicence] & " -13")

[CementCarver]

Excellent, that worked. Thanks for your help Dale.

CementCarver

[rzw0wr]

My pleasure.

Dale