Problems with decimals in an update drop down list

[tim19260]

Hi,

I'm working with Mysql and Php.

I have a drop down list on an update form that has the values 0.05 and 0.5 as two of the options. When the page is visited the selected value shows up as 0.05, whether the database value is 0.05 or 0.5.

How do I get the appropriate value to be selected?

Thanks for your help.

[bregent]

Is the dropdown list actually bound to the database? Can you paste the code for the dropdown window?

[David_Powers]

Select the drop-down list in Design view, and click the Dynamic button in the Property inspector. In the Dynamic List/Menu dialog box, choose the recordset that contains the values to be displayed, and then click the lightning bolt icon alongside "Select value equal to". Choose the appropriate field in the dialog box that opens.

[tim19260]

Hi David,

I had originally set up static values, but there must have been something wrong with it, all the values except 0.05 and 0.50 displayed correctly.

Like you suggested, I've since scrapped it, and put the labels and values in a MySql table and draw them out of a recordset for the drop down list. It works that way, probably better in the long run, as there are a few pages that need the values, and I'm still determining the value range and increments.

Thanks,

Tim