472,794 Members | 2,168 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,794 software developers and data experts.

Problem printing Memo field

I have a field, data type Memo, in a job details table. I have a text box on
a report which I need to print the contents of this field. My problem is
that the text box will only display 255 characters. How can I get the report
to print this field completely.

Thanks for any help out there.

John.
Nov 13 '05 #1
3 2969
John wrote:
I have a field, data type Memo, in a job details table. I have a text
box on a report which I need to print the contents of this field. My
problem is that the text box will only display 255 characters. How
can I get the report to print this field completely.

Thanks for any help out there.

John.


Query must not have DISTINCT (at all) or GROUP BY (on the memo field).

Report cannot sort or group on the memo field and cannot have a format
property assigned to the control for the memo field.

Access 97 used to simply disallow these things. In A2K and above they
"improved" it so that is accomodates those things by doing a
Left([FieldName], 255) in the background.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2
"Rick Brandt" <ri*********@hotmail.com> wrote in news:VVk2e.5218$yq2.3067
@newssvr12.news.prodigy.com:
John wrote:
I have a field, data type Memo, in a job details table. I have a text
box on a report which I need to print the contents of this field. My
problem is that the text box will only display 255 characters. How
can I get the report to print this field completely.

Thanks for any help out there.

John.


Query must not have DISTINCT (at all) or GROUP BY (on the memo field).

Report cannot sort or group on the memo field and cannot have a format
property assigned to the control for the memo field.

Access 97 used to simply disallow these things. In A2K and above they
"improved" it so that is accomodates those things by doing a
Left([FieldName], 255) in the background.


Sometime ago I was able to successfully group on a memo field in Acc97. I
believe that in the QBE grid you do something like this:

TestField:iif(Len(CStr([MemoField]))=0,"No Text",CStr([MemoField])))

You may need to play around with this but I seem to remember that it
worked. By converting the memo field's value to a string it should allow
the GroupBy to work. Someone else here may be able to verify this?

Hope this helps!

strvariant
Nov 13 '05 #3
Thanks for that, I'll check it out.

John

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:VV*****************@newssvr12.news.prodigy.co m...
John wrote:
I have a field, data type Memo, in a job details table. I have a text
box on a report which I need to print the contents of this field. My
problem is that the text box will only display 255 characters. How
can I get the report to print this field completely.

Thanks for any help out there.

John.


Query must not have DISTINCT (at all) or GROUP BY (on the memo field).

Report cannot sort or group on the memo field and cannot have a format
property assigned to the control for the memo field.

Access 97 used to simply disallow these things. In A2K and above they
"improved" it so that is accomodates those things by doing a
Left([FieldName], 255) in the background.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: euang | last post by:
Hi, I have been using access 2000 for two years on WINDOWS NT to display dynamic aweb page using ASP My ISP has now changed to Windows 2003, and I am having major problems displaying...
3
by: GorDon | last post by:
Hi, I have a report based on a query. The query grabs a memo field from my main table, yet when I display the memo field in the report it truncates the memo field (the field needs to hold more...
3
by: BlackFireNova | last post by:
I am working on an Access 2002 Database. I created a new table and imported some notes data into it from an existing table. Now, when I try to create a List Box, and it displays the list of...
4
by: Mal | last post by:
I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a...
2
by: David | last post by:
I have a table which is to hold 70 memo fields to contain notes on data changes to corresponding fields in a form. The problem is I dont want to have to create 70 forms to input notes into. Is it...
4
by: ghadley_00 | last post by:
I have an access database form where I have a button that is supposed to be appending the contents of 1 memo field to another is behaving non-predictably. The code is: Me! = Me! & Chr$(13) &...
9
by: philip | last post by:
If I execute that : Dim Temp as string = "This is a text" Dim sw As StreamWriter Dim fullFileName as string = "c:\text.txt" sw = New StreamWriter(fullFilename) sw.Write(temp) sw.Close() ...
4
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates...
15
by: sara | last post by:
I have a Memo field in a table to hold notes from a conversation a social worker has had with a client (this is for a non-profit). If the user needs to update the memo field, I need to find the...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
How does React native implement an English player?
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.