I once did something like this when I had to truncate breadcrumbs...
Code:
full = recTmp("thename")
name = Trim(Left(full, numberOfcharacters))
If Len(full) > numberOfcharacters Then
name = name & "..."
End If
Then you can use 'name' to display.
Hope it helps
Jacob.