Prev: HOW CAN I CREATE SIGN IN SHEETS
Next: Error Message
From: ted collins on 27 May 2010 18:01 Used to able to make labels from earlier editions of Access w/o any problems. Since updating to "2007" I wind up with messages popping up and little boxes asking for parameter values for Trim even though I use the Label Wizard and would assume "the Wizard" would/should take care of ninty gritty details. I'm a "user" not a developer or programer. How do I fix this problem so I can just print some labels? -- elderuser
From: Arvin Meyer [MVP] on 28 May 2010 01:26 Open any code window and go to Tools >>> References and look for any marked as "MISSING". If you find any, fix them. Then try and compile the database. You may have to do it again. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access Co-author: "Access 2010 Solutions", published by Wiley "ted collins" <tedcollins(a)discussions.microsoft.com> wrote in message news:FF17A9F9-83B5-43BE-A521-5DF7535DDB7B(a)microsoft.com... > Used to able to make labels from earlier editions of Access w/o any > problems. > Since updating to "2007" I wind up with messages popping up and little > boxes > asking for parameter values for Trim even though I use the Label Wizard > and > would assume "the Wizard" would/should take care of ninty gritty details. > I'm > a "user" not a developer or programer. How do I fix this problem so I can > just print some labels? > -- > elderuser
From: John Spencer on 2 Jun 2010 08:34 Can you post the phone control's source? Is it just a field? OR is it something like ="Home Phone" & [Home Phone] I suspect that you have a display format that shows the phone number fields with the formatting you see (very possibly the format is set at the table field level). The actual value being stored is 1234567890. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County ted collins wrote: > The telephone numbers appear in the format I prefer "(000) 000-0000" > everywhere (tables, queries, reports) except when I select them to appear on > a standard Avery label using the Access Label Wizard. I want up to three > telephone numbers to appear on one line on the label i.e. the fields are: > Home Phone, Work Phone, and Cell Phone. If the phone numbers are already > formatted the way I want them and appear correctly elsewhere why does > selecting them for use in a labels report cause this problem? They appear as: > 1234567890.
From: Ted Collins Ted on 4 Jun 2010 01:56 Each is a field i.e. Home Phone, Work Phone, and Cell Phone in the Database table. At some point I think I selescted the use of the telephone number input mask for data entry and everything appears with (@@@) @@@-@@@@ as the apparent "format" in the table, queries, and reports other than in a label. I looked at these fields in Table>Design View>Properties and note that while the input mask was shown for each, the Format property box was blank. So I typed in the above desired format you gave me with the hope that that would finally be it. No help phone numbers on the labels still appear as 1234567890. "John Spencer" wrote: > Can you post the phone control's source? > Is it just a field? OR is it something like > ="Home Phone" & [Home Phone] > > I suspect that you have a display format that shows the phone number fields > with the formatting you see (very possibly the format is set at the table > field level). The actual value being stored is 1234567890. > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > ted collins wrote: > > The telephone numbers appear in the format I prefer "(000) 000-0000" > > everywhere (tables, queries, reports) except when I select them to appear on > > a standard Avery label using the Access Label Wizard. I want up to three > > telephone numbers to appear on one line on the label i.e. the fields are: > > Home Phone, Work Phone, and Cell Phone. If the phone numbers are already > > formatted the way I want them and appear correctly elsewhere why does > > selecting them for use in a labels report cause this problem? They appear as: > > 1234567890. > . >
|
Pages: 1 Prev: HOW CAN I CREATE SIGN IN SHEETS Next: Error Message |