Re: Ex****ting data from Access to Excel 2003 with combo box proble
by =?Utf-8?B?anVkZSBMaW5uZWxs?= <judeLinnell@[EMAIL PROTECTED]
Nov 24, 2008 at 02:36 AM
Yes the combo box's bound column is populated with a number 1, I have tried
changing to a 0 but it still ex****ts a number to excel instead of the
text.
Could you describe the second column part that you have suggested. thanks
"bhicks11 via AccessMonster.com" wrote:
> Look at the datasource for the combo box. Is your combo box's bound
column
> actually populated with a number? Perhaps what you want is the second
column
> in the combo box. You would do this with:
>
> me.combobox.column(1)
>
> The first column is column 0.
>
> Bonnie
> http://www.dataplus-svc.com
>
> jude Linnell wrote:
> >I have a re****t with a combo box field on it. When I ex****t it to Excel
2003
> >I get
> >all the fields but the one relating to the combo box is returning a
number
> >instead of text.
> >Any ideas less than changing the re****t to have text boxes for these
fields
> >instead of combo boxes.
>
> --
> Message posted via AccessMonster.com
>
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200811/1
>
>