Adding a Y or N to a field if it's Not null in Access 2010

[lg5050]

Hi, i'm trying to figure out how to make this two fields in my form to say Y or N if the field is Not Null. Like if the field is not null = Y Else = N for the two fields. I have a picture to show what i'm talking about. Please help!!

 

[Frothingslosh]

You have a couple of functions you need to use.

IsNull(Argument) returns true or false depending on if the value of the supplied argument is null.

IIf(Argument, TrueResult, FalseResult) determines whether Argument is true or false, and returns the corresponding result.

Put them together, and you would have a control source like this:

=IIf(IsNull(Me.ControlName), "N", "Y")

 

[lg5050]

ok...i have a field called USLine and if i use that code for the USoFlag showing in the picture that show work for the field USLine.