Search results for query: *

I dont think that its corrupted I can see de data just fine when i put the table and the feeld in a query. as soon as I put criterias in other feelds I get chinees caracters only in the memo feeld. and for your information the query has the "group by" on almost all the feelds even on the memo...

its a memo feild it was text and as soon as i changed it i got chinees caracters.

Thanks alot guys....

this is the error: run-time Error '2427' You entered an expression that has no value. this is the start of the code: Private Sub Form_Load() If Me!txtRVID > 0 Then Explenation: the form me is a subform and wen you create a new record my code first loads the form and subform then creates...

thank you both for your help....:)

this is the query SELECT tblTypeStatut.TypeStatut, tblSuivi.RVID FROM tblSuivi INNER JOIN tblTypeStatut ON tblSuivi.StatutTypeID = tblTypeStatut.StatutTypeID WHERE (((tblSuivi.RVID)=197) AND ((tblSuivi.DateStamp)=#01/09/2004 9:3:44#)); the problem is that #01/09/2004 9:3:44# ends up looking...