By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,504 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

NOT FIRST OR LAST

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.