Exporting Data and Bookmarks

[Paolo]

Friends, I have a problem with my Access database when trying to
export data from a form to a Word file.
I use a form to store data in a table. Both table and form are named
CONTACT.
I use a Module to export data into a Word document. I use bookmarks in
Word and have noticed that although I have set my table's field
properties to Capital Letters (>), is type the text into the field on
my form, when I exported to my Word file, it is exported in small
letters. This is strange since after that I type the data in my
fields, the text is automatically converted to Capital Letters.

Any Explanation?

[Pieter Linden]

jp***@tin.it (Paolo) wrote in message news:<9f**************************@posting.google. com>...

Friends, I have a problem with my Access database when trying to
export data from a form to a Word file.
I use a form to store data in a table. Both table and form are named
CONTACT.
I use a Module to export data into a Word document. I use bookmarks in
Word and have noticed that although I have set my table's field
properties to Capital Letters (>), is type the text into the field on
my form, when I exported to my Word file, it is exported in small
letters. This is strange since after that I type the data in my
fields, the text is automatically converted to Capital Letters.

Any Explanation?

Using > is for viewing only. You could use a query to convert the
data to capital letters using UCase$([FieldName]) and base your export
on that.

[Paolo]

Thanks for your reply. This is something new to me. I reall did not
know tha the > was for view only. At this point since the development
of my database if too far ahead to create queries etc. Is there
another way that I can force entries in my tables to be done in
capital letters? Let's say perhaps via code? Do you have some sample
or can give me a help?
Thanks.
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

jp***@tin.it (Paolo) wrote in message news:<9f**************************@posting.google. com>...

Friends, I have a problem with my Access database when trying to
export data from a form to a Word file.
I use a form to store data in a table. Both table and form are named
CONTACT.
I use a Module to export data into a Word document. I use bookmarks in
Word and have noticed that although I have set my table's field
properties to Capital Letters (>), is type the text into the field on
my form, when I exported to my Word file, it is exported in small
letters. This is strange since after that I type the data in my
fields, the text is automatically converted to Capital Letters.

Any Explanation?

Using > is for viewing only. You could use a query to convert the
data to capital letters using UCase$([FieldName]) and base your export
on that.

[Pieter Linden]

jp***@tin.it (Paolo) wrote in message news:<9f**************************@posting.google. com>...

Thanks for your reply. This is something new to me. I reall did not
know tha the > was for view only. At this point since the development
of my database if too far ahead to create queries etc. Is there
another way that I can force entries in my tables to be done in
capital letters? Let's say perhaps via code? Do you have some sample
or can give me a help?
Thanks.

I think there are several ways of doing this... you could format your
bookmarks in Word to be shown capitalized, or you could write some
code in the beforeInsert event of your forms that capitalized all the
text values on your forms (tedious). Personally, I'd use Word...