1) i set date to dmy and i found that i cannot change it to any other format later on in the program. is there any way for me to display the date as dmy in one part and as ymd in another part of the program?

2) i put mytextbox.value = date(), therefore the value would be something like 25/08/1999. Now i want the date to appear in another textbox but as 19990825. how can i do that?

3) i add a combobox as an object in my form using the following code:

add object txtPartName as combobox with;
rowsourcetype = 6, rowsource = 'part.partname', multiselect = .t.

(part being the alias for my table and partname is the field in part)

can anyone tell me if there is anything wrong with my approach and also, is there a way for me to sort the partname in ascending order?

last but not least, sorry for the many questions, but i'm desperate for help. thanks a lot for those who replied to my earlier messages. you guys really helped a lot.