473,655 Members | 3,057 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

help w/ transferring data into report

I'm new to MS Access and having a problem with making a report from an
access database. I can't seem to expand the field in the report I called
"notes" in the database. All the text is cut off and I need to include it
in the report. I don't care if I see the all the text in the database. Can
anyone tell me how to do this in the report? I am trying to learn this
program in a HURRY as I have a project I need to have done by this weekend.
I'm entering several columns of data and then trying to the data into a
concise report with four or five of the columns of data. -thanks
Nov 12 '05 #1
3 1669
"nospamplea se" <no**********@r ochester.rr.com > wrote in
news:Lb******** *********@twist er.nyroc.rr.com :
I am trying to learn this program in a HURRY as I have a project I need
to have done by this weekend.


You'll probably have it mastered by Saturday night and then will contribute a
few hours a week helping others here in the comp.databases. ms-access
newsgroup, right?

I'm not sure I understand your problem but MAYBE, setting the CanGrow
property of the report control to True might help.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)
Nov 12 '05 #2
Mal
Go to the Reports DESIGN view,

Right Click the text box that the "notes" is being displayed in and select
properties (if they aren't already visible)
On the FORMAT tab, look for CAN GROW, and make it YES.

This will allow the text box to grow vertically....t o make it wider, just
resize in the design view.

HTH
Mal.
"nospamplea se" <no**********@r ochester.rr.com > wrote in message
news:Lb******** *********@twist er.nyroc.rr.com ...
I'm new to MS Access and having a problem with making a report from an
access database. I can't seem to expand the field in the report I called
"notes" in the database. All the text is cut off and I need to include it
in the report. I don't care if I see the all the text in the database. Can anyone tell me how to do this in the report? I am trying to learn this
program in a HURRY as I have a project I need to have done by this weekend. I'm entering several columns of data and then trying to the data into a
concise report with four or five of the columns of data. -thanks

Nov 12 '05 #3
Thank you!

"Mal" <ma******@hotma il.com> wrote in message
news:vq******** ****@corp.super news.com...
Go to the Reports DESIGN view,

Right Click the text box that the "notes" is being displayed in and select
properties (if they aren't already visible)
On the FORMAT tab, look for CAN GROW, and make it YES.

This will allow the text box to grow vertically....t o make it wider, just
resize in the design view.

HTH
Mal.
"nospamplea se" <no**********@r ochester.rr.com > wrote in message
news:Lb******** *********@twist er.nyroc.rr.com ...
I'm new to MS Access and having a problem with making a report from an
access database. I can't seem to expand the field in the report I called "notes" in the database. All the text is cut off and I need to include it in the report. I don't care if I see the all the text in the database.

Can
anyone tell me how to do this in the report? I am trying to learn this
program in a HURRY as I have a project I need to have done by this

weekend.
I'm entering several columns of data and then trying to the data into a
concise report with four or five of the columns of data. -thanks


Nov 12 '05 #4

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

Similar topics

6
2873
by: Ishbel Kargar | last post by:
I've bought a new laptop (running Windows XP home edition) to replace my old one (running Windows 98). I don't have cable connection between the two computers, so I've transferred most of the files between the two using RW disk. I'm membership secretary for a charity (1300 members), with another smaller group (25 members), both using Access from MS Office 2000 Premium edition. On the new computer the small Db works fine, address...
3
1810
by: phong.lee | last post by:
Hello all, i'm new at this. I need some assistant in transferring data from excel to access. I created a macro that basically gather all the necessary data that i need to bring into access. I also created a table in access with the correct columns to store the data from excel. Is there a way in VBA code that i can write so that when the data that i need can be automatically transfer into my access table? Thank you
7
1196
by: Jim Bayers | last post by:
We have a read only connection to the remote campus sql server. For security reasons, my network nazi won't let me have a web server on our local server that has this connection. Fine. He want's to isolate our server with the connection to the remote server from the outside world. ---------------------- | Campus server | ---------------------- | ----------------------
6
4984
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing for long running reports. When the processing is complete it uses crystal reports to load a template file, populate it, and then export it to a PDF. It works fine so far....
3
2433
by: Adriano | last post by:
Hello, when I try to print something, either DataGrid or from Crystal Report viever the folowing error message appears and cancels printing: Object reference not set to an instance of an object :(((( Anyone pls help me to solve this problem!!! thanks in advance,
15
5069
by: http://www.visual-basic-data-mining.net/forum | last post by:
Does anyone have any idea how to transferring data from TextBox1 in form1 to textBox2 in form2..... That means after i fill in any data in textBox1 and click Next button... It will bring me to form2....and there the data that i key in form1 will appear to form2 in textbox2 Thanks
3
4383
by: Mike Dee | last post by:
Hi, I'm having an issue with the status bar in Mozilla and Netscape showing that it is still waiting on the page to load even after it is finished. This problem does NOT occur with IE. In summary, I am using a onLoad event in the BODY tag to communicate back to another server each time a page finishes loading. I do this by using a "new Image()" and setting the .src property to the server. The .src includes a value in the querystring...
2
1543
by: Dino | last post by:
dear all, i got this script form a customer. in general, it recieves data which is send via http to a server and generates a .xml file from this data. because i'm not familar with .asp, i'm totally lost transferring this script to php. i don't understand which way the data is recieved and how it's saved. as long this ia a very short script, i post it here. it would bne GREAT if
3
1770
by: DeanL | last post by:
Hi guys, I'm in need of a little help with a report I'm setting up on Access 2000. The report shows data depending on entries on a form that has 7 fields (Min and Max Cost, Fiscal Year, Min and Max Award Dates, Reviewer, Engineer). Some of these fields may have wild card characters (*) and some real data in them. The problem I have is when the user hits the Go button I need to have some text fields on the report show data from the...
0
8296
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8816
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
8710
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...
0
7310
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5627
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
4150
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
4299
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1928
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1598
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.