combobox control

[Jackeb]

Quick question...

Where can I find out about displaying dates in comboboxes, the format changes everytime i use them, how do you control this? Is there a property of the box?

Cheers

Ed

 

[Ivan F Moala]

Use the Comboboxs change to change the
formating of the dates eg.

<pre/>
Private Sub ComboBox1_Change()
ComboBox1.Text = Format(ComboBox1.Text, "dd/mm/yyyy")
End Sub
</pre>

 

[Jackeb]

I have tried this but it effects some other calculations, without having to rewrite my logic is there an easy way to solve this problem??

ed

 

[Ivan F Moala]

On 2002-04-15 01:17, Jackeb wrote:
I have tried this but it effects some other calculations, without having to rewrite my logic is there an easy way to solve this problem??

ed

Ed there is no property to control this.
What calculations are affected, as you can always change the text back to its original
serial date format for calculations eg.

CDate(ComboBox1.Text)

 

[Jackeb]

cheers...

i'll wotk that one!

Ed