Looking for a enhanced word processing report (1 Viewer)

FuzMic

FuzMic

DataBase Tinker
Local time
Today, 15:44
Joined
Sep 13, 2006
Messages
719
Hi members

As I know it, msAccess report, text, unlike word processing, designer have limited control of its appearance.

I am making some reports where text forms a big part of it with some fields from the database. How can i control the text part? In paragraph format i would like to do eg text justified. As for text i would like to enhance eg bold, superscript, italics on certain part of the whole text.

How can i achieve all these?. I was wondering if msaccess report can handling html tags.

I am still using msaccess 03 & 07. I think underneath even, office 2016, the report design has not undergo any major changes.

Please enlighten me. Thank you.
 
Last edited:
isladogs

isladogs

MVP / VIP
Local time
Today, 08:44
Joined
Jan 14, 2017
Messages
18,207
If it is an unbound textbox or bound to a memo field, you can use rich text which allow for text formatting of individual words or sections of text. Rich text is a subset of HTML so will handle many HTML tags but not all.

ACCDB files from v2007 onwards will give you more options than the older MDB files
 
FuzMic

FuzMic

DataBase Tinker
Local time
Today, 15:44
Joined
Sep 13, 2006
Messages
719
Ridders

Thank you, got it.

You mean that if the report field is bounded to a normal text field, latter must be converted to a memo field; right?

When i view a memo field, only from Access 07 we can right click to go into Design View to do rich text formatting. I don't think we can do this from Access 03 at all, right?

I am going to try a few things, please advise if you know the answer

Do i have to have a .accdb to format a memo field?
Can I do the text formatting of a .mdb memo field from Access07?
Once done in Access07, can the formatting remain when i open the file in Access02-03?
 
Last edited:
isladogs

isladogs

MVP / VIP
Local time
Today, 08:44
Joined
Jan 14, 2017
Messages
18,207
Yes it has to be a memo field AKA long text.

I'm fairly sure it wasn't available in A2003 though Stephen Lebans had some clever tools for using rich text in earlier versions. See his website if it matters to you. I've never used them however
 
FuzMic

FuzMic

DataBase Tinker
Local time
Today, 15:44
Joined
Sep 13, 2006
Messages
719
Much appreciate your pointer
 
isladogs

isladogs

MVP / VIP
Local time
Today, 08:44
Joined
Jan 14, 2017
Messages
18,207
Of course the other thing you could consider is using mail merge to export the info you want to a Word document.
 
FuzMic

FuzMic

DataBase Tinker
Local time
Today, 15:44
Joined
Sep 13, 2006
Messages
719
Thank you mate for your advice again. Following is my legacy findings.

  • We can use .mdb (not necessary accdb) with memo field to create rich text forms & report in A07.
  • However these RTF forms & reports when view in msccess below 2007, tags will not resolved.
  • Such .mdb if complied in A02-03 will will run in A07 and all HTML tags will resolve.
All these means only from 2007, msAccess start to interpret HTML tags placed in the database be it .mdb or .accdb.

Do you think Lebans have a simple fix in his huge contribution that allow A03-03 to resolve HTML tags.
 
C

CJ_London

Super Moderator
Staff member
Local time
Today, 08:44
Joined
Feb 19, 2013
Messages
16,601
mdb's (2003 and earlier) used RTF formatting. RTF is a legacy standard that predates HTML and I'm not aware of any current system (access or otherwise) that still uses it as a standard, however it is still supported at the moment for output purposes.

RTF coding uses character code combinations to identify bold/italic etc. HTML, as I'm sure you know, uses tags and has a much richer range of options, tho' still limited compared with say Word.

If you convert/upgrade your .mdb to .accdb, access should automatically convert the RTF coding to HTML, tho' I've never had to do it so cannot confirm.

Access, like many apps is not backwards compatible. Anything written in a later version cannot be used by an earlier version.

Do you think Lebans have a simple fix in his huge contribution that allow A03-03 to resolve HTML tags.
Click to expand...
you have a link to his site, go take a look. My guess is it will need to scan the memo field to substitute html tags with rtf characters and remove all tags that do not have a rtf equivalent - again access has a limited range of codes compared with MS Word of the day.

Found this link which might assist you with understanding the task you are setting yourself.

https://www.codeproject.com/Articles/7087/XHTML2RTF-An-HTML-to-RTF-conversion-tool-based-on


But I have to question why anyone is still using 2003 in a live environment these days
 
FuzMic

FuzMic

DataBase Tinker
Local time
Today, 15:44
Joined
Sep 13, 2006
Messages
719
London something to dig in a few days time. Thank you.

I love old things being much smaller & faster yet can achieve my humble needs. Cheerio!
 
isladogs

isladogs

MVP / VIP
Local time
Today, 08:44
Joined
Jan 14, 2017
Messages
18,207
FuzMic said:
London something to dig in a few days time. Thank you.

I love old things being much smaller & faster yet can achieve my humble needs. Cheerio!
Click to expand...

I'm resisting (just!) the temptation to make a crude response to your last sentence :D
 
isladogs

isladogs

MVP / VIP
Local time
Today, 08:44
Joined
Jan 14, 2017
Messages
18,207
LOL.
Your response was on the right lines
 
You must log in or register to reply here.

Similar threads

M
What is the Best Approach: Query for a Report
Replies
1
Views
275
plog
P
A
Can you hide blank text boxes (rows) in a report?
Replies
14
Views
623
MajP
MajP
J
Getting a Word doc into Access
2
Replies
34
Views
1,422
jpl458
J
GinaStar
Suggestions for a report?
Replies
11
Views
799
Pat Hartman
P
C
Copying currency values from Access to paste into Word
Replies
12
Views
1,604
MajP
MajP

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom