View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default forms / text boxes

I have 2 questions:

First, is there a way to format a text box for dates. One of the text boxes
on my form is for the user to enter a date. I would like to format the text
box so all the user has to do is enter mmddyy and the field is automatically
populated as mm/dd/yy.

Second, is there a way select the entire field in a form. Once the user
clicks enter on the form, a number of edits are performed. If there is an
issue with the field, I would like to move the cursor back to the field in
question (setfocus - no problem) but then I would like to select whatever is
in the text box, so the user can just key over the existing info.

Thanks for the help........
--
JT