Hide last character in textbox

  • Thread starter Thread starter martin
  • Start date Start date
M

martin

How can I do this? Under certain conditions I want to
hide the last character but the field contains between 6
and 9 characters, so I can't use the Left or Right
functions....
 
martin said:
How can I do this? Under certain conditions I want to
hide the last character but the field contains between 6
and 9 characters, so I can't use the Left or Right
functions....
Click to expand...

And you can't use the Right function because...?
 
You do not say exactly where/how you want to use this expression, so here is
the syntax using the Left() and Len() functions:

Left([MyField], Len(Trim([MyField]))-1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Textbox - Hide Cursor 0
Count first and last characters 3
string expression help 1
Advice for field structure or query structure - not getting theresults I thought I should 2
Hide non-printing characters. 5
Display of character "&" in titles, headers or labels 2
Display or hide control characters in Excel 2007 1
Hiding certain characters in a text box (similar to password) 2

Back
Top