Search results

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

I would only need 2 moved to the left (person's name & title row) and (orgname row). The other ones are individual set to line up with their particular categories so they would not move.

See attached. If a person does not have an image, I would like the text to be left aligned, otherwise it should show the image to the left and the text should be left aligned to the right of the image.

How are these?

PS -- I have no idea where to find the SQL.

Ok -- here you go. The manager image that I have on the print preview is fine. It's the medium blue section that I want to include a picture for that level of manager.