Adam-
All the columns in a combo box are converted to text data type. If you want to drop the leading zero in any of the values, you'll have to use a Format function call in your combo box Row Source to force it to not include the leading zero. Keep in mind that if you do that, you won't be able to enter 0.35 to get a match.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 19, 2015, at 3:51 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a drop down box based on a table of currency amounts. The field is limit to list, with a prompt and script to update the underlying table if a new amount is entered. The problem is, for example, 0.35 is in the list. It recognizes "0.35" but if I try to enter ".35" it thinks it's not in the list. Is there a way around that?
Adam
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar