B
Bart
I am having a display issue with a form that I am using as a subform in
datasheet view. When run alone everything works fine but as a subform it does
not initially display a vertical scroll bar even though there are more
records than can be displayed in the space available. To see the other
records it is necessary to use the navigation buttons on the keyboard to move
down the list. Scroll bars will appear once navigation forces a row over the
top end but all records below the original set of visible records will not
show any dividing lines between rows.
This subform drives another subform that displays an image based on a value
found in the selected record of the above datasheet. I have narrowed the
problem down to the following function:
Function setImagePath()
' Hide the built-in navigation buttons
Parent.NavigationButtons = False
Dim strImagePath As String
On Error GoTo PictureNotAvailable
strImagePath = Me.smallImagePath + Me.photoNumV + Me.fileType
Me.Image16.Picture = strImagePath
' Turn the built-in navigation buttons back on
Parent.NavigationButtons = True
Exit Function
Commenting out the "strImagePath = " statement eliminates the problem but of
course is essential to my application.
Is there something wrong with this statement, or is there something else I
can do fix this problem?
Any help would be appreciated.
Access 2000
Windows XP
datasheet view. When run alone everything works fine but as a subform it does
not initially display a vertical scroll bar even though there are more
records than can be displayed in the space available. To see the other
records it is necessary to use the navigation buttons on the keyboard to move
down the list. Scroll bars will appear once navigation forces a row over the
top end but all records below the original set of visible records will not
show any dividing lines between rows.
This subform drives another subform that displays an image based on a value
found in the selected record of the above datasheet. I have narrowed the
problem down to the following function:
Function setImagePath()
' Hide the built-in navigation buttons
Parent.NavigationButtons = False
Dim strImagePath As String
On Error GoTo PictureNotAvailable
strImagePath = Me.smallImagePath + Me.photoNumV + Me.fileType
Me.Image16.Picture = strImagePath
' Turn the built-in navigation buttons back on
Parent.NavigationButtons = True
Exit Function
Commenting out the "strImagePath = " statement eliminates the problem but of
course is essential to my application.
Is there something wrong with this statement, or is there something else I
can do fix this problem?
Any help would be appreciated.
Access 2000
Windows XP