Report the numeric position of the 1st character in a string

[alice R via AccessMonster.com]

I have created strings that are 31 (?) long

" X X C O O O " First Character = 5 (or 4 + 1 - if I
have to add 1 that's fine)
"X XXX XXX XXX X XXX" First Character = 1 (or 0 + 1)
" O X X X " First Character =18 (or 17 + 1)

What function (easy no VB loops please) will give me a number to work with?

I've tried Mid() and Code() but I must be missing a step.

Thanks!

--
Timber, his arms open.
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[Douglas J. Steele]

So you want to know how many blanks are at the beginning?

Len(MyString) - Len(LTrim(MyString))

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"alice R via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:52***********@AccessMonster.com...

I have created strings that are 31 (?) long

" X X C O O O " First Character = 5 (or 4 + 1 - if
I
have to add 1 that's fine)
"X XXX XXX XXX X XXX" First Character = 1 (or 0 + 1)
" O X X X " First Character =18 (or 17 + 1)

What function (easy no VB loops please) will give me a number to work
with?

I've tried Mid() and Code() but I must be missing a step.

Thanks!

--
Timber, his arms open.
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200508/1

[alice R via AccessMonster.com]

Douglas J. Steele wrote:

So you want to know how many blanks are at the beginning?

Len(MyString) - Len(LTrim(MyString))

OH! Of course!!! Brilliant!!

Thank you!

--
Timber, his arms open.
Message posted via http://www.accessmonster.com