What's the different betwee this right() code?

O

ooxx

Dear

You can test for this and the different in results

strt = Right(Text1, 8)
Me.Text14 = Right(Text1, 5)
strt = Mid([Text1], [Text3], 1)
num2 = Left(strt, InStr(1, strt, " "))

while the me.Text4 shown as it was, not the strt.

Any idea
Thanks
 
D

Douglas J. Steele

I'm afraid your question isn't very clear.

You might try reposting with actual sample data for Text1 and Text3, showing
us what's going wrong.
 
O

ooxx

hehelohehehe

I'm having the problem of trying to write one function to convert number
either have string "." or no "." string to compare for and to convert it very
complicated to do for example ; $250.23 convert to : Two hundred and fifty
dollars and twenty three cent. In here, you might notice that there is the
ucase and lcase . With this to do, there is trouble. Any idea.

Thanks

Douglas J. Steele said:
I'm afraid your question isn't very clear.

You might try reposting with actual sample data for Text1 and Text3, showing
us what's going wrong.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



ooxx said:
Dear

You can test for this and the different in results

strt = Right(Text1, 8)
Me.Text14 = Right(Text1, 5)
strt = Mid([Text1], [Text3], 1)
num2 = Left(strt, InStr(1, strt, " "))

while the me.Text4 shown as it was, not the strt.

Any idea
Thanks
Click to expand...
Click to expand...
 
D

Douglas J. Steele

You still haven't really explained what the code sample you gave does.
However, if you're trying to convert numbers to text, take a look at
http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



ooxx said:
hehelohehehe

I'm having the problem of trying to write one function to convert number
either have string "." or no "." string to compare for and to convert it
very
complicated to do for example ; $250.23 convert to : Two hundred and
fifty
dollars and twenty three cent. In here, you might notice that there is
the
ucase and lcase . With this to do, there is trouble. Any idea.

Thanks

Douglas J. Steele said:
I'm afraid your question isn't very clear.

You might try reposting with actual sample data for Text1 and Text3,
showing
us what's going wrong.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



ooxx said:
Dear

You can test for this and the different in results

strt = Right(Text1, 8)
Me.Text14 = Right(Text1, 5)
strt = Mid([Text1], [Text3], 1)
num2 = Left(strt, InStr(1, strt, " "))

while the me.Text4 shown as it was, not the strt.

Any idea
Thanks
Click to expand...
Click to expand...
Click to expand...
 
Top