I was curious in regards to Access 12; specifically more fluent report
formatting.
I'm an average user, but from my end, I find more and more need for
cleaner reports....and do not always want to merge with Word. Although
I believe my reports are very clean and well laid out, they always tend
to look more like an office form, with underlined spaces that require
to be filled in.
As an Example, I just built a report for Wills, and a lot of text
fields need to be placed into the report within a lot of standard text.
Most of the text boxes need to be underlined and bold, this presents
the form look, I don't want. As I do not know how big a persons name
will be, I have to ensure I leave enough space to accommodate for
this...which not always gives the clean consecutive feel to the
paragraph(s), and sentence structures formatting which could be
achieved in Word, i.e.
I _____Billy Bob Bloggins_______ _______________ , declare this.....
vice
I Billy Bob Bloggins, declare this.....
Additionally, I can live without word wrap (would be nice, but I
appreciate the difficulties in this), but the need for Full
Justification is always an issue. I know there are ways to achieve
this (Steven Lebans), but is would be nice to have this incorporated
directly in Access.
Anyway, I was just wondering if some of these issues have been
considered in the new Access version.
Cheers,
Dave 6 1590
In message <11************ **********@z14g 2000cwz.googleg roups.com>, Dave
<da**********@g mail.com> writes I _____Billy Bob Bloggins_______ _______________ , declare this..... vice
I Billy Bob Bloggins, declare this.....
You can do that by defining text variables to hold boilerplate text then
concatenating the variables in the report. I think that will do what you
want, and it will work in current versions of Access.
If you decide to try this take a look at the difference in the way the
"&" and "+" operators work for concatenation. The difference can be
quite useful at times.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.
Concatenating like this: ClientNames: ([GivenName] & " "+[Surname])
But I'm still not sure how to apply this to make my report format
flow better, when I cannot guarantee the size of a persons name; some
names could be 10 characters, while others could be 30...
How could I make the paragraph flow, without large spaces to
accommodate variable name sizes? How will the paragraph stretch using
just the above?
Is there an example I could review?
Cheers,
Dave
In message <11************ **********@g49g 2000cwa.googleg roups.com>, Dave
<da**********@g mail.com> writes Concatenatin g like this: ClientNames: ([GivenName] & " "+[Surname])
Yup!
But I'm still not sure how to apply this to make my report format flow better, when I cannot guarantee the size of a persons name; some names could be 10 characters, while others could be 30...
Concatenation tricks help if, for instance, you want to include a middle
initial if there is one. If you concatenate the name, one space each
side of the name and the boilerplate text you don't have any extra
spaces in the paragraph. You end up with just one text box the full
width of the page with all of the text of the paragraph in it. How could I make the paragraph flow, without large spaces to accommodate variable name sizes? How will the paragraph stretch using just the above?
Is there an example I could review?
None of my work is online.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.
Sorry, I'm still unsure of how to apply your suggestion correctly.
Do I add all the text for a paragraph within the one text field?? i.e.:
([GivenName] & " "+[MInitial]& " "+[Surname])
Would look like this:
|
I, ([GivenName] & " "+[MInitial]& " "+[Surname]), agree to be bound by
the provisions of this Agreement and agree to determine by this
Agreement, in the event we cohabit and later.....blah, blah, blah. And
we contiune here.....
How do I add the other text to the para...if you could further clarify,
that would be most helpful.
Your patience's is appreciated!
In message <11************ *********@g14g2 000cwa.googlegr oups.com>, Dave
<da**********@g mail.com> writes Sorry, I'm still unsure of how to apply your suggestion correctly.
Do I add all the text for a paragraph within the one text field?? i.e.:
([GivenName] & " "+[MInitial]& " "+[Surname])
Would look like this: | I, ([GivenName] & " "+[MInitial]& " "+[Surname]), agree to be bound by the provisions of this Agreement and agree to determine by this Agreement, in the event we cohabit and later.....blah, blah, blah. And we contiune here.....
That's about it. You need to include all of the text for that paragraph.
That will make sure that there are no gaps either side of the places
where you insert the variable data
For clarity I would create some text variables to carry the boilerplate
text. So in this case you would have some text before the name, then
some more after the name. In my applications I would write some code to
do the concatenation. I would write a function that accepts the names
and the other text and concatenates them. That way I could easily use
the same code in different projects. The function would include some
code like this:
-------------------------------------------------------------------------
------
dim ForeMatter, AfterMatter, Para1 string
ForeMatter= "I, "
AfterMatter=", agree to be bound by the provisions of this Agreement and
agree to determine by this Agreement, in the event we cohabit and
later.....blah, blah, blah."
Para1=Forematte r + [GivenName] +" " + [Minitial]&" " + [Surname]+
AfterMatter
-------------------------------------------------------------------------
---------
This takes you down to the end of the paragraph containing your
variables.
When the names are printed it is possible that the number of printed
lines will change. Long names might add an extra line to the paragraph.
So you need the following paragraph to print one line further down the
page. If you set the Can Grow property of the text box to true it will
be able to expand. That should move the following fields further down
the page.
How do I add the other text to the para...if you could further clarify, that would be most helpful.
Following text boxes can be labels or more text boxes populated from the
database. If you intend to write many similar reports then it is worth
trying to find ways to automate parts of it by using code.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.
Thanks for all your help! I think that I'll review info on Word
Merges; they may apply and simplify my reporting needs.
Again, your patience's has been refreshing!
Have a safe and wonderful Christmas / Holiday Season! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Richard |
last post by:
Hi,
I have a form that take some time to load due to many comboboxes and at
least 8 subforms.
When I filter or sort the main form I get an error message and then Access
shuts down. They ask if I want to send the error report to Microsoft. Has
anybody seen this type of error message and what can I do to prevent it from
happening. Am I doing something illegal in my code? It used to work but I
have added conditional formatting to a subform...
|
by: Mike MacSween |
last post by:
tblCourses one to many to tblEvents.
A course may have an intro workshop (a type of event), a mid course
workshop, a final exam. Or any combination. Or something different in the
future.
At the moment the printed output is usually going to Word. It's turning into
an unholy mess, because I'm having to prepare umpteen different Word
templates, and the queries that drive them, depending on what events a
course has.
|
by: (Pete Cresswell) |
last post by:
I'm doing a booklet for a class reunion. Got all the data and everybody's life
history in a little MS Access app and now it's time to get the booklet ready to
go to the printer's.
I have a report that creates same, but rather than send it to a printer of PDF
file, I'd prefer to get it into MS Word, PageMaker, or some other document
editor. Reason: some people have sent in pictures, and I'd like to flow the
text around their pix.
...
|
by: Andrew Chanter |
last post by:
Does anyone know a way you can use conditional formatting to create a banded
style view as is commonly seen on the internet. (In othe words the first
record appears on a gray background, the 2nd on white, the third on gray etc
etc.) I could write an expression based on the odd/even status of the
primary key but this wont work when sorting and filtering is applied.
Any suggestions gratefully received.
|
by: hank755_ca |
last post by:
Hello,
I have a report in Access which I want to export to Excel with the
formatting intact. The formatting is rather complex with several
headings and fields with borders. I have tried the "Analyze This"
command but the formatting is totally lost.
Is there a way I can save as much of the formatting as I can? Are their
third party software that can do this?
| |
by: dcyale |
last post by:
I have a report with the following paragraph:
="This BA presents a " & & " determination for the " & & " and associated habitat. We would appreciate you processing the biological opinion by " & & ". If you have any questions, please contact ODOT Biologist " & & ", " & & ", " & & ". "
The problem is that the phone number is showing up without any formatting, even though I saved it to the underlying table with the formatting. Since...
|
by: babyangel43 |
last post by:
Hello, I have a query set up in Access. I run it monthly, changing
"date of test". I would like this query to be merged with a Word
document so that the cover letter is created in Word, the fields from
Access are automatically filled into the Word document. The query
could be anywhere from 0-5000 names, one cover letter per name. AND to
this cover letter for each applicant, there has to be attached a two
page document. How in the world can...
|
by: smuir |
last post by:
I am working with a basic access form for a payroll system and need to modify it such that if an employee worked overtime, then their overtime payrate and hours show up on the report below their regular payrate and hours.
Ex:
40.00 hours @ $77.00/hr
5.00 hours @ $102.00/hr
If an employee's overtime hours = 0, then the overtime payrate and hours fields should not be visible on the report.
Ex: 40.00 hours @ $77.00/hr
|
by: Neil |
last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text
feature does not support: a) full text justification; b) programmatic
manipulation.
I was hoping that someone might know one way or the other whether that was
true or not, or could point me to an article or help text that would. What I
have seen so far online and in Access 2007 help seems to confirm the above.
But that (or at least (b)) seems incredible that it...
|
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...
|
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,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
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...
| |