Len function may be

[gsrajan]

My question might be trivial to you. Please let me know how to do that.


I am able to get the user name of the computer using a function. The function returns the user name in this format: first Name.last name. ( Example: philip.daniel ).

I wish to display only the first name ( the name before the dot. ) in a text box. I think I can use the len function. May be I am wrong. Please let me know how to retrieve only the first name. I also wish to capitalize the first letter.

Thanks for your help.

 

[jdraw]

I would try (untested)

Left(username,Instr(username,".")-1)

 

[gsrajan]

Thank you very much. It works.