Hello,

1. I tried to write a query in MS Access with a criteria that displayed all the records that contained a string that was all CAPS. The criteria used was Ucase([Table1]![Field1]) but it still shows ALL the records. I guess MS Access' queries don't differentiate caps and non caps, is there a way to make this work?

2. I have used the listview control in VB6 so I tried to place one in an MS ACCESS form and everything seemed to go fine until I tried to manipulate it through code. In vb6 I would use the Listview1.Listitems.Add to add items, but there is not Listitems property in the Listview. How do you add items to the Listview control in ms access?

Thanks!
Thai