Re: Combo box problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is the combo box bound to a field in the form's recordsource? What is the
format that is set for that field if yes?

Do you see the 2 decimal places in the dropdown list? or just in the combo
box after you make a selection?

What is the format for the [Year] field in tblOutput?

Also, do not use Year as the name of a table's or query's field. It and many
other words are reserved words in ACCESS, and can create serious confusion
for ACCESS and Jet. See these Knowledge Base articles for more information:

List of reserved words in Access 2002 and Access 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

List of Microsoft Jet 4.0 reserved words
http://support.microsoft.com/?id=321266

Special characters that you must avoid when you work with Access
databases
http://support.microsoft.com/?id=826763

--

Ken Snell
<MS ACCESS MVP>


"Tom" <Tom@xxxxxxxxxx> wrote in message
news:elB9EcrVFHA.1404@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Allen
>
> Thanks for your input but it makes no difference & setting decimal places
> to Auto or 0 has no effect
>
> any other suggestions?
>
> Tom
> "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
> news:%23wCGtVrVFHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
>> Try setting the Format property of the combo to General Number.
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia.
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "Tom" <Tom@xxxxxxxxxx> wrote in message
>> news:u5NIJ$qVFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
>>> Using Access 2002, have a combo box on a form and using:
>>>
>>> SELECT DISTINCT tblOutput.Year
>>> FROM tblOutput
>>> WHERE (((tblOutput.Year) Is Not Null))
>>> ORDER BY tblOutput.Year DESC;
>>>
>>> as the record source. In the table we have the entries:
>>>
>>> 2005
>>> 2004
>>> 2003
>>>
>>> yet what is seen in the combobox is:
>>>
>>> 2005.00
>>> 2004.00
>>> 2003.00
>>>
>>> Any advise on how to correct this would be appreciated
>>
>>
>
>


.

Relevant Pages

  • Re: Object Dependencies
    ... Allen Browne - Microsoft MVP. ... >ok to delete the Name Autocorrect Log Table or will it ever be needed? ... >>> We are using Office 2003, but kept our database in the 2000 format. ...
    (microsoft.public.access.conversion)
  • Re: Export specification Data Types
    ... Apparantly there was some confusion going on between the redesigned export ... You must explicitly format an integer value to be an ... List of reserved words in Access 2002 and Access 2003 ... List of Microsoft Jet 4.0 reserved words ...
    (microsoft.public.access.queries)
  • Re: Exporting table containing dates
    ... suggestion and again Access is not liking the word "Format". ... "Ken Snell MVP" wrote: ... Now export this query instead of exporting your table. ... Problem names and reserved words in Access ...
    (microsoft.public.access.externaldata)
  • Re: Combo box problem
    ... Remove the fixed in the format so that it is blank ... "Tom" wrote: ... >> many other words are reserved words in ACCESS, ... >> List of Microsoft Jet 4.0 reserved words ...
    (microsoft.public.access.forms)
  • Re: Combo box problem
    ... Tom ... > What is the format for the field in tblOutput? ... > many other words are reserved words in ACCESS, ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.forms)