Recordset - Can't see in form

[Corinne]

Hello,

I'm having a problen having a recordest show up in a form. I designed the application and everyhting connected to the database just fine ..... all information showed up on the form correctly........... I could scroll through the recordset and select another name and the information for the person I selected was accurate. Well, the users had compiled more information in an Excel spreadsheet that they then wanted added to the SQL database for the application. I thought "No problem" I would just import the additional information (new records) into the SQL database. Well I did that and I get the Employees name to show up so it can be selected but when the form is populated none of the information that is in the table shows up in the form. I already had a trim function. I go through debug and for some reason when I select one of the excel imported names the recordset .EOF value is True which would indicate that there are no records. I'm at a loss on where to look next. Has anyone had a problem similar to this? Thanks for any help you can give me.

Corinne

 

[woyler]

It is possible that extra spaces are your problem if you have the field data type set to char. If you have a char data type and a length of 10, and your record is 'Eddie', it will read Eddie^^^^^. If you try to match 'Eddie' with 'Eddie ', your result set will be empty. Try setting the data type to varchar. If that does not work, in your create table scripts, include:

SET ansi_padding off
GO

before the CREATE TABLE statement

 

[Corinne]

Thanks so much for your help!