Re: Combo box problem
- From: "Tom" <Tom@xxxxxxxxxx>
- Date: Thu, 12 May 2005 11:14:05 +0100
Dennis
THANK YOU!
Tom
"Dennis" <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5748A68A-1495-4E09-B132-99EE4B125A57@xxxxxxxxxxxxxxxx
> To fix your combo display problem, on the Year field in the tblOutput
> table,
> Remove the fixed in the format so that it is blank
> Change 0 dp to Auto
>
> "Tom" wrote:
>
>> 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
>> >>>
>> >>>
>> >>
>> >>
>> >
>> >
>>
>>
>>
.
- References:
- Combo box problem
- From: Tom
- Re: Combo box problem
- From: Allen Browne
- Re: Combo box problem
- From: Tom
- Re: Combo box problem
- From: Ken Snell [MVP]
- Re: Combo box problem
- From: Tom
- Re: Combo box problem
- From: Dennis
- Combo box problem
- Prev by Date: Re: Combo box problem
- Next by Date: RE: custom number format help please
- Previous by thread: Re: Combo box problem
- Next by thread: Form Dialogue Box
- Index(es):
Relevant Pages
|
