It's showing Null. I replaced the "" with "N/A" to test that and the "N/A" shows up.

Sorry - I'm a little slow today...

Basically how the expression works is...

IIF(Condition, Value is True, Value if False)

So if the field is null, you should not have anything displayed.
If the field isn't null, then it should display the value in the field.

It sounds like the if it is null part is working. What appears when there is actually a value in the field?

Mike
EchoVue.com

Sorry for jumping in, but you can put two bound textboxes where you want them to show up as lables, and then format them both to can shrink = yes. Alternatively, you can check them liek this:

If IsNull(Me.TextBox1) Or Me.TextBox1 = "" Then
   Me.Textbox1.Visible = True
   Me.TextBox2.Visible = False
   Else
   Me.Textbox1.Visible = False
   Me.TextBox2.Visible = True
End If

Hey, I never said I was elegant.


mmcdonal

Sorry again, I got it backeards:

If IsNull(Me.TextBox1) Or Me.TextBox1 = "" Then
   Me.Textbox1.Visible = False
   Me.TextBox2.Visible = True
   Else
   Me.Textbox1.Visible = True
   Me.TextBox2.Visible = False
End If


mmcdonal

I am fat fingering everything this morning. More coffee is needed...

mmcdonal

Where do I put that code? Right-click in the section of the report where the Textboxes are and do a 'Build Event'?

What is the 'Me.'? Do I need to change that to the name of the report or something?

Thanks again!

Go to the Form's Properties dialog box, select the Events tab, then select the On Open event. Select Code, then put the code there.

Me refers to the form or report that the code is on and is a relative reference.

Access database objects have absolute references in this format:

For example, if you have a control called txtMyTextBox on a report called rptMyReport, you can refer to it in code like this using the absolute reference:

[Reports]![rptMyReport].[txtMyTextBox]

This is also called Bang Dot notation.

If you want to refer to the same control with code in an event on rptMyReport, you can eliminate the object and item reference and use:

Me.txtMyTextBox

If you use the absolute reference as above, you must make sure the item is open, or Access will tell you it doesn't exist. So if you want to refer to a combo box on a form from a query (common) you can only use the query when the form is open, or Access will tell you the form doesn't exist and won't let you open the query (or it will return no results).

Does this help?



mmcdonal

Ok, it's showing that both textboxes are null. I gotta be missing something obvious here...

When you say "it" is showing both text boxes null, what does that mean?

Is there a case where both text boxes would be empty? If so, create a label, and then put it on top of the other two text boxes and add code to the report to make it appear if both text boxes are null or empty.



mmcdonal

Now I'm gettin this when running it...

'You entered an expression that has no value'