Re: Combo box problem

Ken

Thanks for input, answers inline

Tom

"Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
news:%236uw%23erVFHA.2740@xxxxxxxxxxxxxxxxxxxxxxx
> 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?
>

Combo is unbound

> Do you see the 2 decimal places in the dropdown list? or just in the combo
> box after you make a selection?
>
In the dropdown list
> What is the format for the [Year] field in tblOutput?

Field set as Number, Long Integeer, Fixed, 0 Decimal places
>
> 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:
>
point taken - will correct
> 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: Combo box problem
    ... Tom ... > Remove the fixed in the format so that it is blank ... >>> many other words are reserved words in ACCESS, ... >>> List of Microsoft Jet 4.0 reserved words ...
    (microsoft.public.access.forms)
  • 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: fixed length file to excel? VBA macro possible?
    ... Tom was pointing out that Excel expects every row to be the same, ... Because i need to format the lines that start with say 02 differently ... Dim FileName As String ...
    (microsoft.public.excel.programming)
  • Re: Combo box problem
    ... Tom ... >> Field set as Number, Long Integeer, Fixed, 0 Decimal places ... >>> many other words are reserved words in ACCESS, ... >>> List of Microsoft Jet 4.0 reserved words ...
    (microsoft.public.access.forms)
  • Re: Query Help Please! Is a Weekly data format Possible?
    ... Thanks for the reminder, Tom. ... "Tom Ellison" wrote: ... the DatePart function I used will work on a date that is in string ... That is why I asked for the format. ...
    (microsoft.public.access.queries)
Quantcast