txtbox and dddd and getting the text out

[swarv]

Hi all,

I have a text box (txt_day) that populates itself when another box is changed. One box displays the date and txt_day displays the day.

I would like to get what txt_day displays into a string.

I currently have:

inputday = Me.txt_day

But this returns (example) 12/05/2009 .

How can I get it to display the word Tuesday for example.

Thanks

Swarv

 

[pbaldy]

You could use the Format() function.

 

[swarv]

great cheers. that bit works fine I hope.