RANGE in ROWSOURCE, POSSIBLE?

[Guest]

hi guys,

I would like to list down the following values in my ROW SOURCE TYPE -
"Value List":

0 - 10,000
10,001 - 20,000
20,001 - 30,000
30,001 - so on..

My problem is, I cant use 'COMMA' in my entry...

What should i do and how to do it? If you can give me other options, then
better..

Thanks..

Amsuria

 

[Al Campagna]

amsuria
Try...
"0 - 10,000", "10,001 - 20,000", "20,001 - 30,000", etc....

 

[Guest]

yeah, thanks..

hehehe.. so simple and yet i havent think of it..

thank you so much... that was really great!

amsuria

 

[Guest]

awww! i tried to include it in my EVENT PROCEDURE and still, i got syntax
error - "EXPECTED END OF STATEMENT" ...

my code:

ElseIf cmbSearchWhat.Value = "Cubic Meter" Then
cmbSearchField.SetFocus
cmbSearchField.RowSourceType = "Value List"
cmbSearchField.RowSource ="1-10,000";"10,001-20,000"

tnx

amsuria

 

[Marshall Barton]

In this context, you need to use a string that results in
what Al said. Your assignment statement needs to be:

cmbSearchField.RowSource =" ""1-10,000"";""10,001-20,000"" "

 

[Guest]

yay! i got it!!!

THANKS AL and MARSHALL!....

amsuria

In this context, you need to use a string that results in
what Al said. Your assignment statement needs to be:

cmbSearchField.RowSource =" ""1-10,000"";""10,001-20,000"" "
--
Marsh
MVP [MS Access]

awww! i tried to include it in my EVENT PROCEDURE and still, i got syntax
error - "EXPECTED END OF STATEMENT" ...

my code:

ElseIf cmbSearchWhat.Value = "Cubic Meter" Then
cmbSearchField.SetFocus
cmbSearchField.RowSourceType = "Value List"
cmbSearchField.RowSource ="1-10,000";"10,001-20,000"