Multi-choice Boxes

[Infamous Blob]

Hello folks
I'm having a small problem with the database I've recently created.

Whenever I fill in a form sheet, everything works as it should, but, if I go back to that form sheet, two of the muliple choice feilds which should be filled in are not filled. Regardless of this, the data is inserted into the table as it should be.

I've checked through the properties of the areas with no sucess, not noticing anything which I think should cause problems. I'm very inexperienced with the program though, not ever having used any database applications before using the software, so this probably doesn't carry much weight.

All help appreciated.

Thanks in advance

[voobase]

Hi there,

Are you using "Radio Buttons" as the multiple choice control? If so, go to design mode for the form (right click the form in GUI and choose "edit"). In design mode right click on the control. Ungroup it from its label and then right click again and go to the control properties. Click on data tab and check what value you have for "reference value on" and "reference value off". Also check what data field it is bound to. The other thing to check is the data type for the field in the database table. In the GUI right click on the table and choose edit. If its a boolean field I think you use 1 for ref value on and 0 for ref value off. See this post for more on boolean and radio buttons.... http://www.oooforum.org/forum/viewtopic ... lean+radio .

If it wasn't this, then have a look at some of the multi choice fields that are working and see if you can see any differences with data type or ref on/off compared with the multi choice radio buttons which aren't working.

Cheers

Voo

[Infamous Blob]

Thanks for the help, most appreciated, although despite how many times I look through it, I just cant see any variations with the fields that are normal whatsoever. The table looks fine as well. Yes it is radio buttons BTW.

[voobase]

Sounds like it doesn't want to play ball! Are there any macros in use with the form? Also, what is the data type of the fields in question. Does it hold integer numbers such as 1, 2 3 or 4 depending on which radio is selected. Also, are they "group box" style of radio buttons or individual radio buttons set up manually?

Voo

[Infamous Blob]

No macros in the form - it's just fields combined with text at the moment. I may expand on it later, but right now I'm just trying to get the basic things I need into the form and into the database itself.

The data type is text (TEXT [VARCHAR]) for both of the two fields. There are no integers in any of the text. I set them all up manually, adding the critical stuff in bit by bit after I'd performed a couple of tests and had worked out what did what.

Again, thanks for the help

[voobase]

No macros in the form - it's just fields combined with text at the moment.

I guess, check the text is identical, including capitals, in your table as to what is displayed in the "ref value on" fields in the radio button's properties. I know you've probably already done that though I'm guessing. How many "radio buttons" access the one database field. I think that you shouldn't have anything in the "ref value off" fields, only the "ref value on" if you are sharing the one table field between many "radio button" controls.

Yeah it's a funny one. If you want, and the database is not of a sensitive nature, you could always upload it to this thread and myself or someone else could have a quick look at it for you, or just PM it to me. Otherwise, make a backup copy and try recreating the fields which you are having trouble with and maybe they will come good.

Cheers

Voo

[Infamous Blob]

At most it's six, but surprisingly that's the one of the two which work.

I think that it may have something to do with the length of what's going into the table - the ones with shorter text are the ones that are fully functional, while the ones that aren't are the ones that aren't working as they should. The stuff that's going into the table is all right though, and non of them go over the limit I've set (this is a little high at 100, but I deliberately set it to a big number after I started getting error messages relating to that).

I've uploaded the file anyhow. I've uploaded it to here.

Again, thanks for all this - I must be a bit a burden by now.

[voobase]

Again, thanks for all this - I must be a bit a burden by now.

No worries, I'm happy to (try to) help!

Just had a look at the database and yes, very weird. I too could not see any differences that would cause that bug. If you go to "view" then "toolbars" and turn on the "form Navigation" toolbar, you can use that toolbar to add in another record or move between them. I did this and found that when you go back and fourth between the two records, everything seems to be working correctly. It is only on initial loading of the form that this bug seems to occur. Additionally, If you first go to design mode (right click on the form and choose Edit) and then use the "Design Mode/On Off" button, the form works fine. The problem only occurs when you start the form by double clicking it in the GUI.

I think that it may have something to do with the length of what's going into the table

I think the length of the data is OK, as it behaves the same for the short words like "cream" as for "environmental green".

For the moment I'm stumped! I'll have another look at it tomorrow (it's getting late here). Maybe someone else might be able to spot whats going on in the meantime.

Cheers

Voo