Right now I have this in my Default Value property for a text field:
=[Forms]![Login]![txtUsername]
My question is, for the username that the user will enter will always have some letters and numbers followed by an underscore "_" then their initials. How do I change this expression so that whatever characters follow the underscore are taken and not the whole username? For example:
Username: D1UXM_JDO
I would like the field to only take "JDO".
Thanks for the help.