text in unattached label

[Guest]

I want to put a line of numerals in an unattached label on a form -- like:
1 2 3 4 5 6 7
evenly spaced across the label with some space in between each numeral. How
can I insert 'fixed' spaces of some kind? Or, is there another way?

Thanks,

Meredith

 

[Al Campagna]

Meredith,
I don't understand... you'd do it just the way you typed them in your message, with a
space (or 2 or 3) between each number until you fill the label width left to right.

 

[John Vinson]

I want to put a line of numerals in an unattached label on a form -- like:
1 2 3 4 5 6 7
evenly spaced across the label with some space in between each numeral. How
can I insert 'fixed' spaces of some kind? Or, is there another way?

Thanks,

Meredith

Well, you can certainly set the Caption property of the label to

"1 2 3 4 5 6 7"

or

"1 2 3 4 5 6 7"

I'm not certain what you mean by "fixed" spaces! Will these numbers
vary over time? What is the purpose of this label?

John W. Vinson[MVP]

 

[Guest]

The form is being displayed in an Outlook email message -- when it shows up
there, the spaces I've entered in Access are eliminated and the numerals are
all just in one string ...

Meredith

 

[John Vinson]

The form is being displayed in an Outlook email message -- when it shows up
there, the spaces I've entered in Access are eliminated and the numerals are
all just in one string ...

Well, that certainly changes the nature of the question and the
possible solutions. Any particular reason you chose not to mention
this in your original post!?

How are you "displaying" the Form? as HTML? If so, you might try
encoding appropriate formatting HTML directly in the label caption.

John W. Vinson[MVP]

 

[Al Campagna]

Well, that's a different problem...
Tell you what you can try. Use the high ascii character Alt-160 (Arial or MSSans). In
most fonts that is a "blank" character.

Type in 1
Hold the Alt key while you type this into the num pad... 0160
Release the Alt key
This should create a what appears to be a "space" but is really a blank High Ascii
character. Access shouldn't strip it out... it doesn't recognize it as a real space.
Type in 2... and repeat the Alt-0160 process.
etc...

Can't say for sure, but I think that might do it.

 

[Guest]

That's a good idea -- The label has 3 lines of text, though, so I don't know
if the Caption property will let me do that?

I'm actually relatively new to this ... and, in answer to a previous
question, I didn't mention the fact that I'm using this form in Outlook as a
survey because I didn't know that was relevant ... sorry

Meredith

 

[Guest]

The label is 3 lines of text that serves as instructions for answering
questions that follows; so, the instruction is basically that you can rate
something between the numbers 1 and 7 from Totally Disagree to Completely
Agree, etc. I wanted it to look (based on what my boss wants) sort of like:

Use the following to rate each statement:
1 2 3 4 5 6 7
Strongly Disagree Neutral Strongly Agree

If I were doing this in Word or Publisher, I'd just insert Em spaces as
needed to evenly space out the numerals, but I can't do that in Access as far
as I know..

Thanks,

Meredith

 

[Al Campagna]

Meredith,
Is there some reason why you didn't try my last suggestion?
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

I'm in the process of trying it -- inserting spaces using your method does
seem to work. I'm still having problems creating a 3-line label, however;
Access Help says to use a Ctrl Enter to indicate the end of a line but I
still get a run-on text as in:

First line text 2nd line text starts here

etc.

I have actually typed:

First line text [Ctrl Enter] 2nd line text etc.

The numerals are on the 2nd line and I tried inserting the characters you
suggested between the 1st and 2nd numerals and that part is working!! Thank
you!

Meredith

 

[Al Campagna]

Meredith,
Use 3 labels... one for each line of text.
Let us know how you make out...

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I'm in the process of trying it -- inserting spaces using your method does
seem to work. I'm still having problems creating a 3-line label, however;
Access Help says to use a Ctrl Enter to indicate the end of a line but I
still get a run-on text as in:

First line text 2nd line text starts here

etc.

I have actually typed:

First line text [Ctrl Enter] 2nd line text etc.

The numerals are on the 2nd line and I tried inserting the characters you
suggested between the 1st and 2nd numerals and that part is working!! Thank
you!

Meredith

Meredith,
Is there some reason why you didn't try my last suggestion?
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

Thank you; I'll try that. Could I make the 3 lines look as if they are one
label by changing the border properties to "None" or something like that?
Actually, I don't see how that would work ...

If I get that little issue solved, I should be home free -- at least for
this form!

Thanks very much,

Meredith

Meredith,
Use 3 labels... one for each line of text.
Let us know how you make out...

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I'm in the process of trying it -- inserting spaces using your method does
seem to work. I'm still having problems creating a 3-line label, however;
Access Help says to use a Ctrl Enter to indicate the end of a line but I
still get a run-on text as in:

First line text 2nd line text starts here

etc.

I have actually typed:

First line text [Ctrl Enter] 2nd line text etc.

The numerals are on the 2nd line and I tried inserting the characters you
suggested between the 1st and 2nd numerals and that part is working!! Thank
you!

Meredith

Meredith,
Is there some reason why you didn't try my last suggestion?
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

The label is 3 lines of text that serves as instructions for answering
questions that follows; so, the instruction is basically that you can rate
something between the numbers 1 and 7 from Totally Disagree to Completely
Agree, etc. I wanted it to look (based on what my boss wants) sort of like:

Use the following to rate each statement:
1 2 3 4 5 6 7
Strongly Disagree Neutral Strongly Agree

If I were doing this in Word or Publisher, I'd just insert Em spaces as
needed to evenly space out the numerals, but I can't do that in Access as far
as I know..

Thanks,

Meredith


:

On Tue, 29 Aug 2006 13:34:02 -0700, MeredithS

I want to put a line of numerals in an unattached label on a form -- like:
1 2 3 4 5 6 7
evenly spaced across the label with some space in between each numeral. How
can I insert 'fixed' spaces of some kind? Or, is there another way?

Thanks,

Meredith

Well, you can certainly set the Caption property of the label to

"1 2 3 4 5 6 7"

or

"1 2 3 4 5 6 7"

I'm not certain what you mean by "fixed" spaces! Will these numbers
vary over time? What is the purpose of this label?

John W. Vinson[MVP]

 

[John Vinson]

First line text [Ctrl Enter] 2nd line text etc.

Are you literally typing square bracket - C - t - r - l and so on? Or
holding down the Ctrl key and pressing the Enter key?

John W. Vinson[MVP]

 

[Guest]

Holding down the Ctrl and Enter keys; is that incorrect?

Meredith

First line text [Ctrl Enter] 2nd line text etc.

Are you literally typing square bracket - C - t - r - l and so on? Or
holding down the Ctrl key and pressing the Enter key?

John W. Vinson[MVP]

 

[John Vinson]

Holding down the Ctrl and Enter keys; is that incorrect?

What works for me is to hold down Ctrl and press Enter. Or, you can
manually set the Caption property in form design to

"1 2 3 4 5 6 7" & Chr(13) & Chr(10) & "the rest of the text"

John W. Vinson[MVP]