Re: Combo box problem
- From: Dennis <Dennis@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 02:56:04 -0700
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
> >>>
> >>>
> >>
> >>
> >
> >
>
>
>
.
- Follow-Ups:
- Re: Combo box problem
- From: Tom
- Re: Combo box problem
- 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
- Combo box problem
- Prev by Date: Re: subform resetting settings
- Next by Date: Re: Combo box problem
- Previous by thread: Re: Combo box problem
- Next by thread: Re: Combo box problem
- Index(es):
Relevant Pages
|
