473,702 Members | 2,436 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3029
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*********@ho tmail.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(L en(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*********@ho tmail.com> wrote in message
news:VV******** *********@newss vr12.news.prodi gy.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.
--
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
5790
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 information from MEMO fields within the Access 2000 database. I have not had any problems before displaying MEMO fields on NT and have tried various tips to resolve this issue but no luck so far. I was wondering if anyone had come accross a similar...
3
10206
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 than 255 characters). The table holds all the memo text, but the query seems to truncate the memo field to 255 chars? This seems like there should be a relatively easy fix, but I can't seem to find it.
3
2805
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 fields to select from, I can see every field in the new table EXCEPT the VNotes field, (which is the one I imported the existing Notes data into). Can anyone help me understand why the existing text notes could be causing Access to make the field...
4
5401
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 memo field When CAN GROW is set to NO everything works just fine. When CAN GROW is set to YES - watch out.... One record causes BIG
2
1562
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 possible to have one form that somehow opens up the correct notes field to input the notes. I was thinking along the lines of having a button against each line of data which then opened this form. Below is the form layout with the notes field...
4
2168
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) & Chr$(10) & Me! & Chr$(13) & Chr$(10) & Me! Me! = Me! & Chr$(13) & Chr$(10) & Me! & Chr$(13) & Chr$(10) & Me! DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
9
8158
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() the resulting file 'Text.txt' has the same length than the string 'temp'.
4
3155
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 hundreds (perhaps even an infinite loop...I have to break the system to stop the report generating) of pages. While I'm not 100% I think this may have something to do with the detail
15
7367
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 original record (which I am doing fine - getting the correct key) and I need to update the "notes" with the new value from the form, which I store in a String Variable. (I've tried storing in a Variant variable; didn't work for me)
0
8738
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9234
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9086
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8979
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
5907
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4412
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4667
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3104
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2399
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.