Command buttons jump sideways on hover (1 Viewer)

fluid

Registered User.
Local time
Yesterday, 18:40
Joined
Nov 27, 2008
Messages
81
I found the source of the problem.
bad VBA Programming...


There is a Public sub that gets called on the "Form_Current" Event of some of the forms. It is used to set the Read/Write privileges based on user level.

Once I commented out the lines with NavigationButtons and RecordSelectors, the problem went away.
I'm speculating that the settings were changing while the form was being used and messing with the apparent position of the controls.



here is the code..


Code:
Sub FrmUserPerm(CurFrm As String)
Dim frm As String

frm = CurFrm

Select Case TempVars![user_level]
    Case 1
        'Forms(frm).NavigationButtons = True
        'Forms(frm).RecordSelectors = True
        Forms(frm).AllowAdditions = True
        Forms(frm).AllowEdits = True
        Forms(frm).AllowDeletions = True
    Case 2
        'Forms(frm).NavigationButtons = False
        'Forms(frm).RecordSelectors = False
        Forms(frm).AllowAdditions = True
        Forms(frm).AllowEdits = True
        Forms(frm).AllowDeletions = True
    Case 3
        'Forms(frm).NavigationButtons = False
        'Forms(frm).RecordSelectors = False
        Forms(frm).AllowAdditions = True
        Forms(frm).AllowEdits = True
        Forms(frm).AllowDeletions = True
    Case 4
        Forms(frm).AllowAdditions = True
        Forms(frm).AllowEdits = True
        Forms(frm).AllowDeletions = True
End Select

End Sub
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:40
Joined
Oct 29, 2018
Messages
21,455
I found the source of the problem.
bad VBA Programming...


There is a Public sub that gets called on the "Form_Current" Event of some of the forms. It is used to set the Read/Write privileges based on user level.

Once I commented out the lines with NavigationButtons and RecordSelectors, the problem went away.
I'm speculating that the settings were changing while the form was being used and messing with the apparent position of the controls.
Hi. Congratulations! Glad to hear you got it sorted out. I just got home and was about to check my email but thought to check the forum first. Lucky me! Good luck with your project.
 

Users who are viewing this thread

Top Bottom