trimming text

[Blakey300]

Hi

I have a surname field which i want to be able to trim in an unbound field
to only show the first 3 charecters.

Ie:

[LastName] [Unbound]

Blake Bla

Regards


Dave

 

[Arvin Meyer [MVP]]

Use the Left() function:

Left([LastName], 3)

 

[Blakey300]

thanks Arvin

I know it was something simple but just having a dizzy blonde day!!!

regards

dave

Use the Left() function:

Left([LastName], 3)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi

I have a surname field which i want to be able to trim in an unbound field
to only show the first 3 charecters.

Ie:

[LastName] [Unbound]

Blake Bla

Regards


Dave