"Peter D" <da*********@pandora.be> wrote in message
news:2f*************************@posting.google.co m...
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