Show users first name in a form label

S

Stephen

Hi All

I've never done string manapulation so dont tknow the functions available
and any examples seem to be for Excel, and cant find anything on the web so
thought I would post here.

I'm using a function to get the full users logon name but I want to present
just the first name in a label control i.e.

Full Name = Joe Smith

I want the label to show 'Joe'

Can anyone help or point me to an url?
 
O

Ofer

Use the split function to split the string with space, and get only the first
name


Me.LableName.Caption = split(FunctionNameThatReturnFullName," ")(0)
 
S

Stephen

Ofer- Thanks, that is perfect.

Ofer said:
Use the split function to split the string with space, and get only the first
name


Me.LableName.Caption = split(FunctionNameThatReturnFullName," ")(0)
Click to expand...
 
Top