Changing combo boxes to Option Groups

[Venus]

I've created a form using the form wizard and all of the fields show up as combo boxes. I would like to change a couple of them to option groups with radio buttons. Is there anyway to do this without deleting the fields and making the option boxes from scratch? The reason I ask is because when I do the option boxes from scratch with the wizard, it alters the way the information shows up in the datasheet (it's a split form).

 

[EternalMyrtle]

The reason I ask is because when I do the option boxes from scratch with the wizard, it alters the way the information shows up in the datasheet (it's a split form).

How is it altering the way the data shows up? Is a number appearing instead?

Is the data in the combo box text or numerical? Are you using a lookup or a value list?

If you were changing from text box to combo or list (or vice versa) you can right click and select "change to" but you cannot change to an option group. With option buttons, you are by default saving the data as a number (aka the "option value") so the data is not interchangeable. Does this make sense??

 

[EternalMyrtle]

By the way, you can change the field's data type in the table to number and put in something like this for the value list (presuming you are using a value list):

1;"Current Employee";2;"Former Employee";0

Put the options group on your form. Then in your data sheet form, change the control to a combo box and change the column setting so that the second column is showing (text, not number). I like to include zero with no text value. I then set the default value of the control on the form to zero so that a value is always entered. This is helpful for searching and filtering.