trying to use a variable as a part of a string....why is this

[sparks]

tempname = FindSpaces(rs![column 1])
this works fine but if I try to pass a variable value to it

For i = 1 To 3 Step 2
tempname = FindSpaces(rs![column (i)])

why can't the variable i just be used in this way?
Is it because of the space in the name column 1 or is
it something else?

thanks for any pointers

Jerry

[DickChristoph]

Hi Jerry

try instead

dim strName as string

For i = 1 To 3 Step 2
strname = "Column " & trim(str(i))
tempname = FindSpaces(rs.fields(strname))
next

-Dick Christoph
"sparks" <js******@swbell.net> wrote in message
news:ua********************************@4ax.com...

tempname = FindSpaces(rs![column 1])
this works fine but if I try to pass a variable value to it

For i = 1 To 3 Step 2
tempname = FindSpaces(rs![column (i)])

why can't the variable i just be used in this way?
Is it because of the space in the name column 1 or is
it something else?

thanks for any pointers

Jerry

[sparks]

that did it thanks a lot.
but why do you have to rebuild the string, is it because of the space
in the name?

Jerry
On Wed, 05 Apr 2006 15:34:10 GMT, "DickChristoph"
<dc********@yahoo.com> wrote:

Hi Jerry

try instead

dim strName as string

For i = 1 To 3 Step 2
strname = "Column " & trim(str(i))
tempname = FindSpaces(rs.fields(strname))
next

-Dick Christoph
"sparks" <js******@swbell.net> wrote in message
news:ua********************************@4ax.com.. .

tempname = FindSpaces(rs![column 1])
this works fine but if I try to pass a variable value to it

For i = 1 To 3 Step 2
tempname = FindSpaces(rs![column (i)])

why can't the variable i just be used in this way?
Is it because of the space in the name column 1 or is
it something else?

thanks for any pointers

Jerry

[DickChristoph]

Hi Jerry

No It is because the syntax of VBA doesn't allow a variable in this context.

Given this it would expect the field name is "column (i)" which not only
isn't what you want but has nothing to do with the value of i.

tempname = FindSpaces(rs![column (i)])

-Dick Christoph
"sparks" <js******@swbell.net> wrote in message
news:ov********************************@4ax.com... that did it thanks a lot.
but why do you have to rebuild the string, is it because of the space
in the name?

Jerry
On Wed, 05 Apr 2006 15:34:10 GMT, "DickChristoph"
<dc********@yahoo.com> wrote:

Hi Jerry

try instead

dim strName as string

For i = 1 To 3 Step 2
strname = "Column " & trim(str(i))
tempname = FindSpaces(rs.fields(strname))
next

-Dick Christoph
"sparks" <js******@swbell.net> wrote in message
news:ua********************************@4ax.com. ..

tempname = FindSpaces(rs![column 1])
this works fine but if I try to pass a variable value to it

For i = 1 To 3 Step 2
tempname = FindSpaces(rs![column (i)])

why can't the variable i just be used in this way?
Is it because of the space in the name column 1 or is
it something else?

thanks for any pointers

Jerry