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)
 
Back
Top