Hide last character in textbox

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....
 
R

Rick Brandt

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...?
 
C

Cheryl Fischer

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