Turning Check Box into a Button

[Liam Murphy]

How would I make a macro or VB code to change a check box into a button? An odd question, but I already have a db set up and working, but I have changed the form
I am using, and check boxes dont work for the format, but buttons will. Would I just have to change the data format in the records from yes/no into something else?
Each box or button is a yes in a field when clicked, and although it is not a normalized way of creating a db, it works for what I am trying to do.

 

[John W. Vinson]

How would I make a macro or VB code to change a check box into a button? An odd question, but I already have a db set up and working, but I have changed the form
I am using, and check boxes dont work for the format, but buttons will. Would I just have to change the data format in the records from yes/no into something else?
Each box or button is a yes in a field when clicked, and although it is not a normalized way of creating a db, it works for what I am trying to do.

Don't confuse data STORAGE with data DISPLAY. They are separate tasks with
different requirements!

You can certainly use a command button to change the value of a yes/no field,
or you could use the existing "Toggle Button" control bound to the field,
rather than a checkbox. The simplest way would be just to open the form in
design view, rightclick the control, and choose Change To... Toggle Button. Is
there some reason that you need to do this with VBA? And do you really want to
be able to change the field to Yes if it's clicked, but not provide any way to
change it back?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Liam Murphy]

Didn't realize there was a "Change To" function, I only mentioned the VBA because I wasn't sure if there were such a simple answer as yours. The toggle button should do what I need, thanks!