microsoft access courses - change caption toggle button

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » microsoft access courses - Change caption on toggle button depending on underlying record

microsoft access courses - Change caption on toggle button depending on underlying record

resolvedResolved · Low Priority · Version Standard

Ricardo has attended:
Access VBA course
Access Advanced course

Change caption on toggle button depending on underlying record

Hi

I have a form ( Frm_InvoiceRecord ) with a toggle button (CheckCMD), which is sourced to a checkbox in a table ( InvoiceTable ).

How can I alter the toggle button such that when the checkbox in the table is ticked the toggle button is pressed down, and the caption reads "Checked", and if the checkbox is unticked the toggle button is not pressed and reads "Unchecked".

Also the button needs to be unlocked for new records, such that a user can click it and it changes from "Unchecked" to "Checked". I have done this with the OnClick event, however I am having some problems with the first part

Any help would be gratefully appreciated.

Thanks

Ricardo

RE: Change caption on toggle button depending on underlying reco

Don't worry - I've worked it out myself.

It's simply a case of putting the code in the On Current event for the form in question (in my case Frm_InvoiceRecord).

Thanks anyway

Ricardo

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips


Server loaded in 0.05 secs.