DISABLE BUTTON ON CONTINUOUS FORM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I'd like to be able to disable/hide a button on a continuous form.
The issue is that this button is on every record, and I only want to disable
this for certain records based on some criteria.

I have searched and found articles that say this can't be done. Does anyone
know how to do this? Thanks.
 
Hello. I'd like to be able to disable/hide a button on a continuous
form. The issue is that this button is on every record, and I only
want to disable this for certain records based on some criteria.
Click to expand...

Put one button in the Form Header or Form Footer and use the OnCurrent
event to enable it or disable it depending on the current record.

Hope that helps


Tim F
 
You should be able to use conditional formating to change the value of
the buttons visible property to TRUE or FALSE as needed.
 
The FormatConditions object does not expose the standard Visible
property nor does it support CommandButton controls. The best the OP can
do is to use a TextBox control, formatted to resemble a CommandButton,
and apply CF to that to make the TextBox background color match the
sections BG color to make it seem to dissappear. The OP would also have
to use CF to set the Enabled prop to No so that the user could not click
on the control.
Sample code is here:
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top