Displaying MS Access fields over 255 characters (Memo fields) 
Author Message
 Displaying MS Access fields over 255 characters (Memo fields)

In CR8.5 is there a way to display a MS Access memo field that holds over
255 characters?

The only workaround I can think of is to split the field up into blocks of
255 and display each in a separate formula.

Is there an easier way?



Sat, 31 Jan 2004 03:09:03 GMT  
 Displaying MS Access fields over 255 characters (Memo fields)
I have version 8.0 and the only thing i do is have the field property
CanGrow to True, will hold any memo
Right Click on a text field in CR and click on Can Grow

Any Help?

--
Patrick Garceau
(450) 658-8741 Poste 411




Quote:
> In CR8.5 is there a way to display a MS Access memo field that holds over
> 255 characters?

> The only workaround I can think of is to split the field up into blocks of
> 255 and display each in a separate formula.

> Is there an easier way?



Sat, 31 Jan 2004 03:39:42 GMT  
 Displaying MS Access fields over 255 characters (Memo fields)
I don't work with MS Access, but in configuring my ODBC driver connection
for a Lotus Notes Database, in "options" I can change the number of
characters for text fields - the default is 254 - I can change it up to
15000!!

Hope this helps!


Quote:
> In CR8.5 is there a way to display a MS Access memo field that holds over
> 255 characters?

> The only workaround I can think of is to split the field up into blocks of
> 255 and display each in a separate formula.

> Is there an easier way?



Sat, 31 Jan 2004 06:20:50 GMT  
 Displaying MS Access fields over 255 characters (Memo fields)
Never used anything else than access with cr8, sorry for my response.

--
Patrick Garceau
(450) 658-8741 Poste 411




Quote:
> I don't work with MS Access, but in configuring my ODBC driver connection
> for a Lotus Notes Database, in "options" I can change the number of
> characters for text fields - the default is 254 - I can change it up to
> 15000!!

> Hope this helps!



> > In CR8.5 is there a way to display a MS Access memo field that holds
over
> > 255 characters?

> > The only workaround I can think of is to split the field up into blocks
of
> > 255 and display each in a separate formula.

> > Is there an easier way?



Sat, 31 Jan 2004 20:15:13 GMT  
 Displaying MS Access fields over 255 characters (Memo fields)
I have fixed this now. I had changed the field type from Text to Memo in
Access but forgotten to Verify Database within CR (Embedded Reports
Component) to update the changes to the report.

Thanks


Quote:
> Never used anything else than access with cr8, sorry for my response.

> --
> Patrick Garceau
> (450) 658-8741 Poste 411




> > I don't work with MS Access, but in configuring my ODBC driver
connection
> > for a Lotus Notes Database, in "options" I can change the number of
> > characters for text fields - the default is 254 - I can change it up to
> > 15000!!

> > Hope this helps!



> > > In CR8.5 is there a way to display a MS Access memo field that holds
> over
> > > 255 characters?

> > > The only workaround I can think of is to split the field up into
blocks
> of
> > > 255 and display each in a separate formula.

> > > Is there an easier way?



Mon, 02 Feb 2004 05:34:52 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Cannot store > 255 characters in Memo field

2. Access memo field won't accept more than 255 chars

3. ASP page won't display text from MS Access Memo field

4. Ken Getz, can you adivse re: adhInsertAtBookmark from Handbook truncates memo fields at 255

5. Strings > 255 from Memo fields

6. memo fields : truncating to 255 car

7. Memo field updates longer than 255 chars

8. Strings longer than 255 characters into word field using vb6

9. Data in varchar(2000) field truncated at 255 characters on report

10. Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters

11. Why is field is truncating at 255 characters?

12. CDO - problem with database fields over 255 characters long

 

 
Powered by phpBB® Forum Software