A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Combo box



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 14th 07, 10:36 AM posted to microsoft.public.outlook.program_forms
skar3000
external usenet poster
 
Posts: 3
Default Combo box

Hi

I am having problems with a drop down list in a custom form.
When ever I add fields, outlook replaces the comma with a semi colon.
For example I need to add "On site, out of office", this then becomes
"Onsite; out of office" and they get seperated in two drop down options (On
site on one line, out of office below it).

Does anyone perhaps have a suggestion on how I could ensure that this stays
one line as one option in the drop down??

Thank you

../Ghamz

Ads
  #2  
Old June 14th 07, 12:35 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Combo box

You didn't say how you're populating the rows. The easiest solution might be to make that one "Onsite - out of office."

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"skar3000" wrote in message ...
Hi

I am having problems with a drop down list in a custom form.
When ever I add fields, outlook replaces the comma with a semi colon.
For example I need to add "On site, out of office", this then becomes
"Onsite; out of office" and they get seperated in two drop down options (On
site on one line, out of office below it).

Does anyone perhaps have a suggestion on how I could ensure that this stays
one line as one option in the drop down??

Thank you

./Ghamz

  #3  
Old June 15th 07, 08:03 AM posted to microsoft.public.outlook.program_forms
skar3000
external usenet poster
 
Posts: 3
Default Combo box

Thanx for you reply, I am trying to populate the list 2 ways:
using the possible values on the control properties (in form design mode)
and the Control.PossibleValues object in the VBScript editor.
Both seem to do the same thing,

I have mentioned that we should leave the comma out or replace it with a -
or / but we would unfortunately need to hav a comma.

any other suggestions??

Thank you

"Sue Mosher [MVP-Outlook]" wrote:

You didn't say how you're populating the rows. The easiest solution might be to make that one "Onsite - out of office."

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


  #4  
Old June 15th 07, 02:14 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Combo box

Never use PossibleValues in code. It will cause the item to one-off, embedding the form definition in the item so that it never runs code again.

If you're goind to use Possible Values on the control's Properties dialog, you can't use commas, because that's a delimiter.

Either change the text for the row so that it doesn't include a comma or use the Rows property or AddItem method to populate the rows. See http://www.outlookcode.com/article.aspx?ID=32

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"skar3000" wrote in message ...
Thanx for you reply, I am trying to populate the list 2 ways:
using the possible values on the control properties (in form design mode)
and the Control.PossibleValues object in the VBScript editor.
Both seem to do the same thing,

I have mentioned that we should leave the comma out or replace it with a -
or / but we would unfortunately need to hav a comma.

any other suggestions??

Thank you

"Sue Mosher [MVP-Outlook]" wrote:

You didn't say how you're populating the rows. The easiest solution might be to make that one "Onsite - out of office."


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding calender in a combo box Mark the Outlook Idiot Outlook - Using Forms 2 February 7th 07 07:26 PM
Combo Box values resetting [email protected] Outlook - Using Forms 2 October 31st 06 05:01 PM
UserProperties and Combo-type controls Simon Woods Outlook and VBA 4 April 19th 06 07:07 PM
Populate a combo box Steffkm Outlook - Using Forms 4 March 14th 06 09:28 PM
Dropdown controls - List vs Combo Don Smith Outlook - Using Forms 2 January 20th 06 07:46 PM


All times are GMT +1. The time now is 10:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.