Recent content by GMT

I'm still trying many things. Does anyone have any suggestions that have not been mentioned earlier or know what I have done wrong?? Thanks, GMT

Me Again. I still can't get this to work for me. More suggestions would be grand. Thanks, GMT

I have tried the two new suggestions with and without the Trim and it still doesn't seem to be working. I have also tried various orders and ways to put the suggestions together and I am still not having any success. I have had one thing do something different: =([City]&", "&[Province]&"...

This is what I had to begin with that did not work: =Trim([City]&", "&[Province]&" "&[Postal Code]) This is what I tried after reading first suggestion: =Trim([City]&", "&[Province]&" "&StrConv([Postal Code],1)) It still did not have a space between the first three characters and the second...

I am creating a database for a mailing with Canadian addresses. I have formated the Postal Code in the Table, Query, and Form, but when I create the mailing labels the format is lost. The format I put in the Table, Query, and Form is >A0A\ 0A0 This way the letters are all capitalized and...