NOT FIRST OR LAST

#1

In ACCESS 97 : in a txtbox i have *(whateverdata)*
I would like to show on screen (whateverdata), so whithout the 2 *

for the first one i used mid(txtboxname,2)
for the last one i used right(txtboxname,1)

but mid(txtboxname,2) - right(txtboxname,1) doesn't work!! how come?

TX anyone

#2

"Peter D" <dauwe.peter (AT) pandora (DOT) be> wrote

Quote:

In ACCESS 97 : in a txtbox i have *(whateverdata)*
I would like to show on screen (whateverdata), so whithout the 2 *

for the first one i used mid(txtboxname,2)
for the last one i used right(txtboxname,1)

but mid(txtboxname,2) - right(txtboxname,1) doesn't work!! how come?

Mid() and Right return strings. What you have there translates to...

(whateverdata) - *

What you want is...

=Mid(txtboxname,2, Len(txtboxname)-2)

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

NOT FIRST OR LAST

comp.databases.ms-access comp.databases.ms-access

NOT FIRST OR LAST - 12-18-2004 , 07:36 AM

Re: NOT FIRST OR LAST - 12-18-2004 , 07:43 AM