Trim Syntax

[usfarang]

I have a string of 25 characters and I only want the first 5 characters. I don't need to delete the other characters, just display the first 5 characters in another field.


The field that has the 25 characters is named txtKey and the field to display the first 5 characters is name txtpswd

The form is based on a table.

[June7]

You want to save 5 characters to field in table? Don't. Just calculate in query or textbox.

Left([txtKey], 5)

[usfarang]

Thanks, not saving just using.