finding number in text

N

newst

is there anybody to know finding numbers in textbox? i need to find number
where is end of the word (e.g. XXX1, YYYYY2). I want to seperate each other.
I used Val(string) but it didnt work.
thanks
 
F

fredg

is there anybody to know finding numbers in textbox? i need to find number
where is end of the word (e.g. XXX1, YYYYY2). I want to seperate each other.
I used Val(string) but it didnt work.
thanks
Click to expand...

Is it always the last character in the string?

=Right([FieldName],1)
will find the last character

=Left([FieldName],Len([FieldName])-1)
will get the other characters.
 
N

newst

It worked with this way. and I'm just wondering, is there any possible to
convert format number to superscript in textbox?

Thank you Fred.

is there anybody to know finding numbers in textbox? i need to find
number
where is end of the word (e.g. XXX1, YYYYY2). I want to seperate each
other.
I used Val(string) but it didnt work.
thanks
Click to expand...

Is it always the last character in the string?

=Right([FieldName],1)
will find the last character

=Left([FieldName],Len([FieldName])-1)
will get the other characters.
Click to expand...
 
D

Douglas J. Steele

The only way would be to use an RTF control, and use whatever RTF command
generates a superscript. The standard Access textbox cannot do it.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


newst said:
It worked with this way. and I'm just wondering, is there any possible to
convert format number to superscript in textbox?

Thank you Fred.

is there anybody to know finding numbers in textbox? i need to find
number
where is end of the word (e.g. XXX1, YYYYY2). I want to seperate each
other.
I used Val(string) but it didnt work.
thanks
Click to expand...

Is it always the last character in the string?

=Right([FieldName],1)
will find the last character

=Left([FieldName],Len([FieldName])-1)
will get the other characters.
Click to expand...
Click to expand...
 
J

John Nurick

Hi Fred,

If you're using a recent version of Access and a well-populated Unicode
font, you can replace the standard number characters with their
superscript counterparts (U+2070 to U+2079). The drawback is of course
that these won't normally be recognised as numbers.

It worked with this way. and I'm just wondering, is there any possible to
convert format number to superscript in textbox?

Thank you Fred.

is there anybody to know finding numbers in textbox? i need to find
number
where is end of the word (e.g. XXX1, YYYYY2). I want to seperate each
other.
I used Val(string) but it didnt work.
thanks
Click to expand...

Is it always the last character in the string?

=Right([FieldName],1)
will find the last character

=Left([FieldName],Len([FieldName])-1)
will get the other characters.
Click to expand...
Click to expand...
 
Top