Show users first name in a form label

[Guest]

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?

 

[Guest]

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


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

 

[Guest]

Ofer- Thanks, that is perfect.

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


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