Hi Scott

Sorry I missed this - as all is now working - and thanks for the interesting info.

I am soon going to start the process of changing over from Access.adp...

Hi Karma

I'm not sure how it works, but it certainly has done the trick.

I just added replace([fieldname],',','') and it all worked.

Best wishes

Paul

Thanks, Chris

Why didn't I think of that?? That is the answer.

Many thanks again

Paul

Hi Ivanna

Thanks for your reply. Personally I've found Access .adp a brilliant working environment. It has all the ease of use and quick development of an mdb, plus...

I have tried to limit the length of the description (course title) string (down to 10 chars). Then, in stages, increased the width of the columns in the combo...

Thanks, Karma, Steve

The text chars of the columns is 7, and a max of 30. The data is drawn from an Oracle server via SQL Server 2000 and needs...

Nope, it wasn't that. It is the strangest thing. I've created a new form. Checked the data by creating a recordset from the code - which all...

Hi Karma

I much appreciate you taking the time to help.

I've been having another look, and tried another form etc.. What I've discovered is that the longer text field was...

Thanks, Jacek0

Gratefully noted.

Paul

Matt

That's fantastic!

Many thanks

Paul

Hi Damon

I absolutely won't. It's always great to get something working.

Best wishes

Paul

Hi Damon

Cracked it! It was just as you suggested, but the problem lay with the ODBC driver. I needed to uncheck Schema, and check NullSchema. Seems a...

Hi again Damon

I was so pleased to see the tables, I didn't think about query syntax.

For Oracle I would use:

select * from LINKEDSERVERNAME..SCHEMA.TABLENAME

For Interbase tables there is no Schema. ...

Hi Damon

Many thanks for all your help. I read through and checked all permissions. I contacted the ODBC driver company and have got a new License Key. ...

Hi Damon

Thanks for your reply. I've done what you suggest and am getting pretty close. I've setup an ODBC driver, and installed the interbase client software. When...