Issue Tracking template contact email addresses

[Poohbear0471]

Good evening. I'm using the pre-made Issue Tracking template in Access 2010. I need one contact to have three email addresses. I updated the field size in the Contacts table to 70 (although the original 50 should have been plenty big enough), however the new contact form will not accept enough characters. I can enter the full data directly into the table, however it is truncated in the form. The email button in the New Issue form creates the email with the truncated addresses. The macro uses a DLookup function to capture the data. I need to have either the full length data populated, or to add additional email fields to the table and have the macro pull all three. I can't find any info on nesting DLookup statements, so I assume this isn't possible. Any suggestions?

[ssanfu]

I changed the e-mail address field in the Contacts table to 255. I modified the form "New Contact" to widen the email address text box to 4.1".
I entered 3 email addresses separated by commas using the form.
I created a new issue, then clicked the email button in the New Issue form. Email opened with 3 email addresses - no truncation.

I changed the email address text box length to 1.5063" and saved the form.
I added a 4th email address using the form, created a new Issue, and clicked the email button. All 4 emails were included.


Don't know what to tell you.......

[Poohbear0471]

Thank you! I didn't try adjusting the size of the field on the form.

[ranman256]

There should never be a reason to nest Dlookups.

[Poohbear0471]

There should never be a reason to nest Dlookups.

. Wow .. Thanks for the extremely helpful input.