I use Initials in Combo Boxes for space conservation on a Form. I don’t depend on the User to enter them, instead, I enter the below in the After_Update event of the Last Name Control on my Form…
Me.txtAssociateInitials = Trim(Left(Me.txtFirstName, 1)) & Trim((" " + Left(Me.txtMiddleInitial, 1))) & Trim((" " + Left(Me.txtLastName, 1)))