Board index » delphi » Access text field changed (in Delphi) into memo field

Adriaan Touw

Delphi Developer
Fri, 28 Jun 2002 03:00:00 GMT

Access text field changed (in Delphi) into memo field

Using a MsAccess database via ODBC with Delphi I have the following problem:
In Access I have a text field with 250 characters. Using this field in
Delphi 4 I see that this text field is changed into a memo field what I
don't like. I can't see the content of this field in a DBGrid anymore.
I've seen that this change happens when an Access text field (255 characters
allowed) is bigger as 127 characters.
Does anyone has a solution?

 --
Adriaan Touw
Sonatelaan 40
3438 TK Nieuwegein

030 6022802
at...@worldonline.nl

 
Jens Kopeck

Delphi Developer
Thu, 04 Jul 2002 03:00:00 GMT

Re:Access text field changed (in Delphi) into memo field


Your problem is documented in the Borland FAQ.

  http://www.borland.com/devsupport/bde/faq/FAQ4779B.html

Using the native driver will do fine.

Jens Kopecky

Adriaan Touw schrieb:

Quote
> Using a MsAccess database via ODBC with Delphi I have the following problem:
> In Access I have a text field with 250 characters. Using this field in
> Delphi 4 I see that this text field is changed into a memo field what I
> don't like. I can't see the content of this field in a DBGrid anymore.
> I've seen that this change happens when an Access text field (255 characters
> allowed) is bigger as 127 characters.
> Does anyone has a solution?

>  --
> Adriaan Touw
> Sonatelaan 40
> 3438 TK Nieuwegein

> 030 6022802
> at...@worldonline.nl

Adam C. Russel

Delphi Developer
Wed, 11 Sep 2002 03:00:00 GMT

Re:Access text field changed (in Delphi) into memo field


I have the same problem; can't seem to find any response - did you get an
answer?
regards,
adam
Quote
Adriaan Touw wrote:
> Using a MsAccess database via ODBC with Delphi I have the following problem:
> In Access I have a text field with 250 characters. Using this field in
> Delphi 4 I see that this text field is changed into a memo field what I
> don't like. I can't see the content of this field in a DBGrid anymore.
> I've seen that this change happens when an Access text field (255 characters
> allowed) is bigger as 127 characters.
> Does anyone has a solution?

>  --
> Adriaan Touw
> Sonatelaan 40
> 3438 TK Nieuwegein

> 030 6022802
> at...@worldonline.nl

Other Threads

1. Text field changed into memo field

2. Memo fields in Delphi and Text fields in MS SQL 6.5

3. Memo Fields in Access and Memo object in Delphi

4. Delphi accessing MS Access Memo Fields

5. MS Access text fields show as memo

6. Help creating an access table with ado (text fields are memo)

7. Access text field shown as Memo

8. Access 97, Delphi 3.02 and the Memo field ...

9. Delphi/Access Blob handles with memo fields

10. Delphi 2.0, Access ODBC & Memo field