space "character" as default value

[LMS]

Hi,
This is not good data I know, but is there a way to have
the default value be a space that actually takes
up "space". I've tried it, but it just doesn't seem to
load an actual space to the field, like it does with any
other character.

The reason is long and will show that we need to be
fixing something else in the process, which we know, but
this would be a good quick fix in the meantime. It has
to do with how the fields print on a form. The lines
print fine if there is something, even a period, loaded
to every field. But periods look funny on the form, so
we'd like to just have a space. (It has to do with a
funny 3rd-party forms printing program built into the
printer. That's about all the detail I can give.)

TIA

 

[fredg]

Hi,
This is not good data I know, but is there a way to have
the default value be a space that actually takes
up "space". I've tried it, but it just doesn't seem to
load an actual space to the field, like it does with any
other character.

The reason is long and will show that we need to be
fixing something else in the process, which we know, but
this would be a good quick fix in the meantime. It has
to do with how the fields print on a form. The lines
print fine if there is something, even a period, loaded
to every field. But periods look funny on the form, so
we'd like to just have a space. (It has to do with a
funny 3rd-party forms printing program built into the
printer. That's about all the detail I can give.)

TIA

As Default Value in the field, what happens if you write:
chr(32)
Does that help fix the alignment?

Why are you printing the form, anyway.
That's what reports are for!

 

[LMS]

Thanx for the quick reply... was wondering if a control
character would do it, but didn't know which to use.
Unfortunately, it doesn't appear to work. When entering
the field, the cursor is right at position 1, and not "2"
like I would expect if a space was loaded in the field.

Sorry for the confusion, it is a report that is printing,
but unless all the fields on the form are filled with
something, the lines are not printing in the correct
positions. We're getting "floating" data, and yes, it is
a partial result of the 3rdparty printer softward in
between the Access data and the actual printed product.

 

[LMS]

I answered too quickly >> obviously the space can't be seen, and when tabbing into the field during entry, the cursor goes to position 1 even when there is a default value there. (This is an annoyance and I'll be looking at how to fix that too.) But if you back up into the field, the cursor is in fact after a space

So, Thank you very much
LM

 

[fredg]

I answered too quickly >> obviously the space can't be seen, and when tabbing into the field during entry, the cursor goes to position 1 even when there is a default value there. (This is an annoyance and I'll be looking at how to fix that too.) But if you back up into the field, the cursor is in fact after a space!

So, Thank you very much!
LMS

Regarding> (This is an annoyance and I'll be looking at how to fix
that too.) <

Code the Enter event of the Control:
Me![ControName].SelStart = Len(Me![ControlName])

On Thursday's, you get 2 for the price of 1.

 

[LMS]

Wow, thanx yet again fredg... as usual, I knew there had to be a way, I just didn't know the way! All the Access books in the world don't get you answers like this

I appreciate your help, and am happy to have learned 2 new things yesterday
LM