Feb 21 2005, 05:00 PM
I've got a form with a combo which has two columns. The first column contains the autonumber which is hidden. The second column is the value which comes from another table. The table is set to currency. the form has no format.
When I select a value from the combo I see the value for instance 185000. when I select the value the form displays it as 185000,000.00.
When I check the table it shows the correct value.
I've been messing around a bit but can't figure it out. I decided to optimize the database when this happened. Before all the values where stored in the same table which meant that values were being repeated.
Any help is truly appreciated
Feb 21 2005, 05:20 PM
What is the 185000 in the combo box supposed to represent? $185,000.00? $1,850.00? Why do you see 185000 in your combo instead of a number preceded by $? Are you using the Format() function anywhere?
Feb 21 2005, 05:41 PM
when I open the combo it shows $ 185000.00 but when I select the value it shows $ 185000,000.00.
it is suppose to show $ 185000.00. the combo on the form has no format whatsoever. I tried to set the format to currency but it changes nothing. The only this setting the format to currency does to format the first column(which is the autonumber) as currency.
The field in the table where the values are stored is formated to currency and this format shows in the combo on the form since it displays $ in the front.
Feb 21 2005, 06:18 PM
"When I select the value..." do you have code in the combo boxes After Update event to copy the amount to the form and that is where you are seeing the $185000.00? Is there any formating for this control?
At this point I have no idea why you are not seeing the correct data in your form when you make a selection from the combo box...
Feb 21 2005, 06:32 PM
I'm not sure how to explain it better. So I've attached the database. If you go to the last record on the opening form it should be clear what I'm trying to explain
Feb 21 2005, 06:37 PM
I am unable to extract the db. I get an error message that I don't have permission or the file is damaged....
Feb 21 2005, 06:42 PM
Weird. Probably because of the special faroese letters.
please try this one
Feb 21 2005, 06:52 PM
I was able to open the second db but I do not understand where your problem lies. If I select a value from one of the many combo boxes it shows what was selected. Where does the wrong number appear?
Also, it appears that you have repeating groups in your table "Tbl_Landsskattur" and if that is the case then you should normalize your data before you go any further with the db...
Feb 21 2005, 07:01 PM
Yes, I know that I have repeating groups. That's what I was trying to correct when I came accross the strange thing.
I thank you for trying to help me Jack. Even when no one know what's wrong they still try to help. That's what I love about this site.
I've taken a screenshot of the error so that you can see that something is wrong at my end.
Thank you again
Feb 21 2005, 07:16 PM
Hmmm. All I can say is that I cannot duplicate your problem. Attached is a .jpg (hopefully) of what I am getting.
Feb 21 2005, 07:23 PM
Yes. It's suppose to look like yours is looking.
The strange part is that I had an older version of the form which wasn't normalized and it worked great.
The new form is exactly the same but with combos instead of textboxes
However I deleted the form when I decided to normalize. But I have several backups. no worries. I should be able to modify the old one so it works the same way the new one does
Feb 21 2005, 07:26 PM
If your data is now normalized you may have to set up a different approach, namely a subform. It seems that you are on the right track so I will wish you good luck and head off into the sunset....
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here