By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,527 Members | 1,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,527 IT Pros & Developers. It's quick & easy.

Access Database Auditing

P: n/a
Hi,

I have a database which is used for a model policy we have and i have a
form where the paragraphs for the policy is put. Now i need a way in
which i can highlight or underline the changes that are made by anyone
for the model policy data. I have searched on google and a number of
sites but come up empty handed.

Any help would be appreciated.

Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Adrian,
Word does this way better than Access. I'd consider embedding a Word
document in a form and use Word's Revision tool to help you with this.

"Adrian Gonzalez" <go*******@gmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
Hi,

I have a database which is used for a model policy we have and i have a
form where the paragraphs for the policy is put. Now i need a way in
which i can highlight or underline the changes that are made by anyone
for the model policy data. I have searched on google and a number of
sites but come up empty handed.

Any help would be appreciated.

Nov 13 '05 #2

P: n/a
Unless you use a Rich Text Box, you cannot underline or highlight text in an
Access Text Box without highlighting or underlining ALL text in that Text
Box. But, without more information on what you have and what you are trying
to do other than a general description, it is going to be impossible for us
to make specific suggestions.

Larry Linson
Microsoft Access MVP

"Adrian Gonzalez" <go*******@gmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
Hi,

I have a database which is used for a model policy we have and i have a
form where the paragraphs for the policy is put. Now i need a way in
which i can highlight or underline the changes that are made by anyone
for the model policy data. I have searched on google and a number of
sites but come up empty handed.

Any help would be appreciated.

Nov 13 '05 #3

P: n/a
Ok here is a more detailed explanation of what i have.
I have a form where all the main headings reside you select the heading
you want then click on a button that takes you to another form with all
the subheadings and information that will be under that main heading. I
then have a textbox for subheadings and a model policy textbox were the
information for under the subheading is entered. I then have accept and
reject checkbox's were if the information is accepted then the data in
the first textbox is copied over to another textbox for the companies
version of this policy. If it is rejected then they input what they
want in the company version textbox. I then have a number of checkbox's
for who the information from the data is for eg: Managers, employees,
or Contractors.

Now when any changes to the data in any of the model policy textbox's
is made i need it to be shown so when anyone access's the form they
know what the last lot of changes were. I know that it can't be done
with normal textbox's but is there some way that it can be done in an
access form.

Nov 13 '05 #4

P: n/a
Ok here is a more detailed explanation of what i have.
I have a form where all the main headings reside you select the heading
you want then click on a button that takes you to another form with all
the subheadings and information that will be under that main heading. I
then have a textbox for subheadings and a model policy textbox were the
information for under the subheading is entered. I then have accept and
reject checkbox's were if the information is accepted then the data in
the first textbox is copied over to another textbox for the companies
version of this policy. If it is rejected then they input what they
want in the company version textbox. I then have a number of checkbox's
for who the information from the data is for eg: Managers, employees,
or Contractors.

Now when any changes to the data in any of the model policy textbox's
is made i need it to be shown so when anyone access's the form they
know what the last lot of changes were. I know that it can't be done
with normal textbox's but is there some way that it can be done in an
access form.

Nov 13 '05 #5

P: n/a
Ok here is a more detailed explanation of what i have.
I have a form where all the main headings reside you select the heading
you want then click on a button that takes you to another form with all
the subheadings and information that will be under that main heading. I
then have a textbox for subheadings and a model policy textbox were the
information for under the subheading is entered. I then have accept and
reject checkbox's were if the information is accepted then the data in
the first textbox is copied over to another textbox for the companies
version of this policy. If it is rejected then they input what they
want in the company version textbox. I then have a number of checkbox's
for who the information from the data is for eg: Managers, employees,
or Contractors.

Now when any changes to the data in any of the model policy textbox's
is made i need it to be shown so when anyone access's the form they
know what the last lot of changes were. I know that it can't be done
with normal textbox's but is there some way that it can be done in an
access form.

Nov 13 '05 #6

P: n/a
If you want to change some properties of an entire Text Box, such as
bolding, italicizing, text color, or background color, you can do so with
the Text Box's Properties. To change parts of the text within a TextBox,
you'll need a Control that handles Rich Text -- there is one that comes with
the Developer Edition of Office XP and earlier (I know there has been some
change in the ActiveX controls that are supplied with the Visual Studio
Tools for Office 2003 System, the current counterpart to the Developer Tools
for Access and do not know if this is one that was omitted), or there are
third-party providers of custom controls for Access, of which FMS, Inc. is
one (http://www.fmsinc.com), who have rich text controls. Finally, MVP
Stephen Lebans has a free rich text control at his site,
http://www.lebans.com (but, like any freebie, it comes with no guarantee of
ongoing support).

If you wish to highlight the whole Text Box, you can keep a separate
"Changed" Yes/No field that you use to set the highlighting; if you choose
to highlight only the changes, then you'll have to store the data with Rich
Text markup.

Larry Linson
Microsoft Access MVP

"Adrian Gonzalez" <go*******@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Ok here is a more detailed explanation of what i have.
I have a form where all the main headings reside you select the heading
you want then click on a button that takes you to another form with all
the subheadings and information that will be under that main heading. I
then have a textbox for subheadings and a model policy textbox were the
information for under the subheading is entered. I then have accept and
reject checkbox's were if the information is accepted then the data in
the first textbox is copied over to another textbox for the companies
version of this policy. If it is rejected then they input what they
want in the company version textbox. I then have a number of checkbox's
for who the information from the data is for eg: Managers, employees,
or Contractors.

Now when any changes to the data in any of the model policy textbox's
is made i need it to be shown so when anyone access's the form they
know what the last lot of changes were. I know that it can't be done
with normal textbox's but is there some way that it can be done in an
access form.

Nov 13 '05 #7

P: n/a
Thanks i'll see how i go with the rich text control

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.