Reply to thread

Message: [QUOTE="John Calder, post: 3348806"] Hi Thanks for your quick response James. The issue I have is not what format is displayed in the spreadsheet cell as I have preformatted the cell to the date format I require. The issue is that in the textbox on the form I have ceated I want it to show a date format there. At present when I enter into the form for example I type 2/4 then I move to the next text box on the form. The problem is that the 1st text box where I entered the 2/4 remains with the display "2/4" when in fact I would like it to display 02-Feb-09 I am not a visual basic programmer so I may have misunderstood your reply. If you are suggesting that I add:- format(cdate(Trim(Me.TxtDate.Value)),"dd/mm/yyyy") to my code then where abount in the code do you suggest I enter it. Thanks John [/QUOTE]