Recent content by JudyK

Thank you so much for providing help. I can't thank you enough. It worked flawlessly. My understanding of code is limited at best and I really appreciate you taking the time to help me. Kind regards, JudyK

I have an image field on a report that keeps showing up even if the field value is null. =IIf(IsNull([Image_tbl4mgr21]),"",[image_tbl4mgr21]) Any idea how to make the white space completely disappear when that image field is empty? Judy

I have a [DOB] field with birth dates. I have another field [DOBExp] where I want to automatically calculate at date 15 days out, but exclude weekends and holidays. I have a separate table listing the holidays. Would like a formula to use in my first table for this. Have no clue how to do...

The name of my Image box is field [Image] from my tbl2DR table. This is what I have in that code: Me.Image.Visible = Not IsNull([tbl2DR.Image_tbl2DR]) If IsNull([tbl2DR.Image_tbl2DR]) Then Me.Text1190.Left = 0 Else Me.Text1190.Left = 550 End If

The name of my actual image is "Image" from table "tbl2DR". I'm getting the following error message now and maybe it's because I didn't do the line items right below. Message say: The Expression On format that you entered as the event property setting produced the following error: Can't...

Ok - I did that. Got a Compile Error: method or data member not found It highlighted the ".Visible ="

Yes I am there now.

It's saved in the table.

=IIf(IsNull([Image_tbl2DR]),"",[Image_tbl2DR]) This is what I'm using in my image box. It sits by itself to the left of the 2 text box lines. Those textbox lines also have the IsNull in them so they disappear when they are empty. The image box still shows up.

It says 555.

Ok, I found it. So now I have a text box for my image field and the syntax you gave me in the on-load part. Now what?

I couldn't find where the Load event was.

Sorry. I have no idea what that means.

0.6875 inches

Image_tbl2DR