Hide contentjpg of a field and still see border - Visible Property in Microsoft Access


	Back to Visible Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Hide contentjpg of a field and still see border

Lyle Bailey

15 months ago

trying to hide image when there is no grade present. but still need the border.
anyway to hide the content but not the border. tried

Private Sub Form_Load()

    If Not IsNull(Me.grade01) Then
        Me.STAFF_INITIALS01.Visible = True
    Else
        Me.STAFF_INITIALS01.Visible = False
    End If
      If Not IsNull(Me.grade02) Then
        Me.STAFF_INITIALS02.Visible = True
    Else
        Me.STAFF_INITIALS02.Visible = False
the border is gine along wit the image

	Lyle Bailey OP @Reply 15 months ago

	Lyle Bailey OP @Reply 15 months ago

	Lyle Bailey OP @Reply 15 months ago
tried Me.STAFF_INITIALS01.Visible = True Me.STAFF_INITIALS01.BorderStyle = True Me.STAFF_INITIALS01.BorderStyle = 1 still no go

	Alex Hedley @Reply 15 months ago
Could have an image of similar size with just a border and show that when there isn't a value in the Table

	Lyle Bailey OP @Reply 15 months ago

	Lyle Bailey OP @Reply 15 months ago

Kevin Robertson @Reply

15 months ago

Instead of controlling the visibility of the object just set the Picture property to an empty string.

Here is a simple example.

    If Not IsNull(EmployeePicture) and EmployeePicture <> "" Then

        imgEmployeePicture.Picture = CurrentProject.Path & "\Images\Employees\" & EmployeePicture

    Else

        imgEmployeePicture.Picture = ""

    End If

This way the Image control is still visible, with the border, but it is empty.

	Lyle Bailey OP @Reply 15 months ago
THIS WORKED TY If Not IsNull(Me.grade01) Then IMAGE01.Picture = CurrentProject.Path & "\Images\" & "BSIN01.JPG" Else IMAGE01.Picture = "" End If

	Lyle Bailey OP @Reply 15 months ago
for a different subject as a FMK(for my knowledge) when I use If Not IsNull(Me.TRACKING22) Then Image22.Visible = True Else Image22.Visible = False End If it only executes once and doesn't change when selecting new record. any help would be appr.

	Kevin Robertson @Reply 15 months ago
On Current

	Lyle Bailey OP @Reply 15 months ago
yeah tried that, somewhere far far away in one of the rick's tech help videos it has something to do with only loads the vba once.

	Lyle Bailey OP @Reply 15 months ago

	Lyle Bailey OP @Reply 15 months ago

	Lyle Bailey OP @Reply 15 months ago

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visible.

Next Unseen

New Feature: Comment Live View