Right and Left Functions

[Jade]

I have a text field that varies in length and I need to
delete the last 4 characters from it. If I use the Right
function as:
Right([txtfield],4)
then it leaves the last 4 characters instead of deleting
them. Also, I can't use the Left function because the
field always varies in length. Is there another function
that I can use? Thanks in advance.

Jade

 

[Paul Overway]

Use Left([txtField]Len([txtField])-4)