You should never use PossibleValues in code. Did you look at the sample form
on the I suggested? It shows exactly how to load rows into a list box or
combo box from a delimited string.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"srm" <(E-Mail Removed)> wrote in message
news:99794827-deb2-4e7f-a664-(E-Mail Removed)...
On Sep 1, 11:57 am, "Sue Mosher [MVP]" <sue...@turtleflock.com> wrote:
> You would need to use code in the form's Item_Open event handler.
> Seehttp://www.outlookcode.com/article.aspx?ID=32for a sample form.
>
> "srm" <s...@primatech.com> wrote in message
>
> news:3d96ff92-e3e6-432b-8ab5-(E-Mail Removed)...
>
> > I'm using O2003, creating a custom form, using the combo box control.
> > I want to add multiple values but within those values I want to use
> > commas. For example
>
> > This is value number 1, and it has a comma
> > This is value number 2, and it has a comma
>
> > However, Outlook thinks the comma is a new entry and it lists the
> > items as follows:
>
> > This is value number 1
> > and it has a comma
> > This is value number 2
> > and it has a comma
>
> > It there a way to add entry using a comma as part of the entry?
>
> > Thank you.
>
> > Shawn
Sue:
Thank you. I don't want to take too much of your time. I got this to
appear on a test form in the "General" and "P.2" tab, but not my
custom form "General" or "P.2" tab. I see the drop down, but no data.
I' think I'm past my capability of coding at this point. I still
cannot get it to accept the commas and I'm not a big coder. Am I close
or over my head at this point and need to look at other options?
Function Item_Open()
' Sets the name of page on the form (General)
Set FormPage = Item.GetInspector.ModifiedFormPages("General")
' Sets Control to a combo box called ComboBox1.
Set Control = FormPage.Controls("ComboBox1")
' Assign values to the combo box.
Control.PossibleValues = "Blue;Green;Red;Yellow"
End Function
Shawn
Similar Threads
