Won't Show more than 255 charaters of text from Database

[Dave]

Small Non-profit site with access to our database of
scholarships. When you access the D-base it cuts off text
at 255 characters. Any sugggestions

 

[Jim Buyens]

-----Original Message-----

Small Non-profit site with access to our database of
scholarships. When you access the D-base it cuts off text
at 255 characters. Any sugggestions

Try opening the table in Access Design View, then changing
the field type from Text to Memo.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Guest]

-----Original Message-----

Try opening the table in Access Design View, then changing
the field type from Text to Memo.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

.

I have tried that but when i do i get this error:
Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'Replace'

/_fpclass/fpdblib.inc, line 33

 

[Jim Buyens]

I have tried that but when i do i get this error:
Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'Replace'

/_fpclass/fpdblib.inc, line 33

Ugh. These are long shots (i.e. psychic) but try either:

o Using a custom query with
SELECT "" & mylongfield as mylongfld, ...
rather than
SELECT mylongfield, ...

o In the finished Database Results Region, right click the column
that displays your long field, choose Database Column Value
Properties, and select Column Value Contains HTML.


Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------