ComboBox (using Commas)

Status
Not open for further replies.
S

srm

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
 
You would need to use code in the form's Item_Open event handler. See

http://www.outlookcode.com/article.aspx?ID=32 for a sample form.

Sue Mosher

"srm" <srm@primatech.com> wrote in message

news:3d96ff92-e3e6-432b-8ab5-5172ccd0ae74@g1g2000vbr.googlegroups.com...
> 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
 
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.
> > Sue Mosher
>    >      >    
> "srm" <s...@primatech.com> wrote in message

> news:3d96ff92-e3e6-432b-8ab5-5172ccd0ae74@g1g2000vbr.googlegroups.com...
>
> > 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
 
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

"srm" <srm@primatech.com> wrote in message

news:99794827-deb2-4e7f-a664-05f4418a0974@o13g2000vbl.googlegroups.com...

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-5172ccd0ae74@g1g2000vbr.googlegroups.com...
>
> > 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
 
On Sep 1, 2:00 pm, "Sue Mosher [MVP]" <sue...@turtleflock.com> wrote:
> 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
>    >      >    
> "srm" <s...@primatech.com> wrote in message

> news:99794827-deb2-4e7f-a664-05f4418a0974@o13g2000vbl.googlegroups.com...
> 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=32fora sample form.

>
> > "srm" <s...@primatech.com> wrote in message

>
> >news:3d96ff92-e3e6-432b-8ab5-5172ccd0ae74@g1g2000vbr.googlegroups.com...

>
> > > 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


Sue:

Thank you. I will check the page again. I appreciate your time.

Shawn
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
S Dynamically add recipients using combobox and checkbox????? Using Outlook 2
K Incorporate selection from combobox into body of email Outlook VBA and Custom Forms 0
T Outlook Template - textbox visible based on combobox selection Using Outlook 1
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
N Select Appointment subject line from combobox or list Outlook VBA and Custom Forms 1
C Autofill subject line in appointment from options selected in combobox Using Outlook 6
B Contact Page 2 Combobox via Registry Outlook VBA and Custom Forms 6
N Combobox in outlook add ons toolbar not firing event on main window resized Using Outlook 3
J userform combobox Outlook VBA and Custom Forms 1
R combobox list in userform Outlook VBA and Custom Forms 1
K Alignment in Combobox Outlook VBA and Custom Forms 1
P Setting combobox properties from Outlook 2007 Add-in Outlook VBA and Custom Forms 9
K Adding watermark to Combobox in Outlook. Outlook VBA and Custom Forms 1
C ComboBox data Outlook VBA and Custom Forms 2
D ComboBox with Multi columns Outlook VBA and Custom Forms 4
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
E Where is the best place to store values for combobox entries Outlook VBA and Custom Forms 5
H using VBA to edit subject line Outlook VBA and Custom Forms 0
e_a_g_l_e_p_i Need clarification on 2-Step Verification for Gmail using Outlook 2021 Using Outlook 10
e_a_g_l_e_p_i Outlook 2021 not letting me setup my Gmail using pop Using Outlook 1
Geldner Problem submitting SPAM using Outlook VBA Form Outlook VBA and Custom Forms 2
O How to find out the domain and server settings that my Outlook is using? Using Outlook 2
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
D Outlook 2021 Using vba code to delete all my spamfolders not only the default one. Outlook VBA and Custom Forms 0
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
R Advise on using multiple instances of network files based on customers Outlook VBA and Custom Forms 8
HarvMan Using Emojis in Outlook 365 Using Outlook 3
T Outlook 2019 Not Using Auto Compete After Deletion of 365 Using Outlook 1
M USING INITIALS AS RECIPIENTS Using Outlook 1
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
M Saving emails using Visual Basic - Selecting folder with msoFileDialogFolderPicker Outlook VBA and Custom Forms 6
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
justicefriends How to set a flag to follow up using VBA - for addressee in TO field Outlook VBA and Custom Forms 11
M Extract "Date sent" from emails (saved to folder using drag and drop) Outlook VBA and Custom Forms 1
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
David McKay VBA to manually forward using odd options Outlook VBA and Custom Forms 1
H Stationery using between OL 2019 and OL 2010 Using Outlook 0
P Prevent Outlook 2016 from using DASL filter Using Outlook 4
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1
M Disable Contact Card Results when using "Search People" in Outlook Ribbon Using Outlook 7
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
S Outlook VBA How to adapt this code for using in a different Mail Inbox Outlook VBA and Custom Forms 0
pcunite Outlook 2019/O365 Build 13127.20408 errors when using MAPI calls Using Outlook 1
B Change Font and Font size using VBA Outlook VBA and Custom Forms 9
M Outlook 2013 reminder email by using Outlook vba Outlook VBA and Custom Forms 2
X Using Outlook 2013 and Outlook 365 Using Outlook 1
A Going to folder using shortcuts Using Outlook 3
A Outlook replies not using "delivered to" address in From Using Outlook 1
Terry Sullivan E-Mails Sent Using a Group Box Result in 70 Kickbacks Using Outlook 4

Similar threads

Back
Top