Short of writing code - not sure how you would change your field names
inside of an existing form. The old field needs to be read and a new field
created so that you can bind it to the correct field on the form itself.
You would only have a potential problem with those field names if these are
going to be used as a field name in a recordset for any reason but should
present no problem within Outlook itself.
For information's sake - there are actually 7 characters that fall into this
category and shouldn't be used in any field name (i.e. Excel column headers
for importing etc) whether allowed or not by the function you are using -
these are:
space - (if found as the first character)
. (period)
! (exclamation point)
` (accent)
[ (left square bracket)
] (right square bracket)
" (double quotation mark)
(in general - it's safest to avoid any kind of special characters such as
"&" etc keeping your name as simple and clean as possible using upper and
lowercase for multipart field names - could save potential issues from
arising if converting to XML).
Karl
PS - Another stumbling block a person can run into is total number of fields
in a contact if you ever chose to export an entire contact record (using
custom code since you can't export user-defined fields using Outlook's
export function) with every field especially if you wanted to include the
"read only" fields used by Outlook (i.e. Creation Date - Last Modification
Date as two simple examples). The maximum number of fields in a Jet engine
based ADO recordset (i.e. MS Access) is 255.
--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com
--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com
Bob said:
I have about 100 contacts already in Outlook and have about 100 (no
kidding) user-defined fields in each contact.
I just discovered that I made'um heap big mistake and created about 9
fields with periods in the name. I spelled doctor Dr., etc.
I don't want to write code to change it (as if I could) and don't want to
cut and paste into new fields that don't have the period.
