ironfelix717
Registered User.
- Local time
- Today, 10:24
- Joined
- Sep 20, 2019
- Messages
- 193
Hi all,
I've finally delved into continuous forms and am enjoying this new discovery. What led me here was the need for a Data Grid / Editable listbox control that i've been dancing around with a lousy (but functional) custom form control. Therefore, my end goal of this form is to simulate such a control using a continuous form.
This topic has 2 questions within it and probably stem from my inexperience with continuous forms.
----------------------
1.) Row Formatting - Substitute conditional format for code solution
I was able to achieve "row" highlighting using the conditional formatting method, which i discovered here: LINK (thank you)
However, conditional formatting appears to be limited (outline formatting? other properties?). So, i was wondering if there is any way to format the "row" with a code event. I tried and tried to format the "row" in the OnCurrent event, etc etc, and could not get past the fact that I was formatting every single row in the form - rather than just the selected row, which makes continuous forms conceptually a bit confusing for me as it relates to events.
2.) Disable textbox entry, allow on DBL Click
The next feature I would like to solve is preventing/handling the auto textbox entry on the form. When a textbox is selected in a continuous form it is immediately entered and ready to accept input. I would prefer if the user had to "enable" the textbox themselves using a double-click. That is the most natural approach. Preventing the textbox from auto-entering on click helps prevent accidental data changes, etc. (yeah, you could just lock the control too, etc. - but it still enters which is awkward IMO).
The solution i initially considered was setting Enabled = False on the textbox in question, and then using DBL Click to re-enable it, but then i remembered disabling the control disabled the events, so no dice there.
Example attached!
I've finally delved into continuous forms and am enjoying this new discovery. What led me here was the need for a Data Grid / Editable listbox control that i've been dancing around with a lousy (but functional) custom form control. Therefore, my end goal of this form is to simulate such a control using a continuous form.
This topic has 2 questions within it and probably stem from my inexperience with continuous forms.
----------------------
1.) Row Formatting - Substitute conditional format for code solution
I was able to achieve "row" highlighting using the conditional formatting method, which i discovered here: LINK (thank you)
However, conditional formatting appears to be limited (outline formatting? other properties?). So, i was wondering if there is any way to format the "row" with a code event. I tried and tried to format the "row" in the OnCurrent event, etc etc, and could not get past the fact that I was formatting every single row in the form - rather than just the selected row, which makes continuous forms conceptually a bit confusing for me as it relates to events.
2.) Disable textbox entry, allow on DBL Click
The next feature I would like to solve is preventing/handling the auto textbox entry on the form. When a textbox is selected in a continuous form it is immediately entered and ready to accept input. I would prefer if the user had to "enable" the textbox themselves using a double-click. That is the most natural approach. Preventing the textbox from auto-entering on click helps prevent accidental data changes, etc. (yeah, you could just lock the control too, etc. - but it still enters which is awkward IMO).
The solution i initially considered was setting Enabled = False on the textbox in question, and then using DBL Click to re-enable it, but then i remembered disabling the control disabled the events, so no dice there.
Example attached!