Text box help

Ah, I see. The If...Then would be necessary only if DefaultValue is dropped
from the code. DefaultValue is redundant with If Me.NewRecord, or If...Then
is redundant with DefaultValue. But would DefaultValue apply any time the
field is blank, whether or not it is a new record, or only with a new record?
I think I remember something from earlier in the thread that the field in
question could be blank.

"Ken Snell [MVP]" wrote:

Your thought about carrying forward the value into new records is what I had
been understanding... but I'm not sure that this is what G.I.O. actually
wants?

A default value will be put into a record only when a new record is being
created. Thus, it should be unnecessary to use the If...Then test that you
suggest.

--

Ken Snell
MS ACCESS MVP

"BruceM" wrote in message
...
I've been watching this thread, and am going to pop in for a moment and
hope
that I don't muddy the waters. In a somewhat similar situation I had
something in the form's On Current event along the lines of:

If Me.NewRecord Then
Me.TheControlName.DefaultValue = """" & Me.TheControlName.Value & """"
End If

The middle part is, of course, the code Ken provided. I suppose this is
really more of a question for Ken than a suggestion that is ready to be
tried. As I understand it, you would want to carry the value forward only
when you are creating a new record.

An ACCESS form will insert the value from the Default Value property only at
the time of creating the new record. If you later delete the value from that
field, it will remain empty until you put something back into it
deliberately.

--

Ken Snell
MS ACCESS MVP

"BruceM" wrote in message
...
Ah, I see. The If...Then would be necessary only if DefaultValue is
dropped
from the code. DefaultValue is redundant with If Me.NewRecord, or
If...Then
is redundant with DefaultValue. But would DefaultValue apply any time the
field is blank, whether or not it is a new record, or only with a new
record?
I think I remember something from earlier in the thread that the field in
question could be blank.

"Ken Snell [MVP]" wrote:

Your thought about carrying forward the value into new records is what I
had
been understanding... but I'm not sure that this is what G.I.O. actually
wants?

A default value will be put into a record only when a new record is being
created. Thus, it should be unnecessary to use the If...Then test that
you
suggest.

--

Ken Snell
MS ACCESS MVP

"BruceM" wrote in message
...
I've been watching this thread, and am going to pop in for a moment and
hope
that I don't muddy the waters. In a somewhat similar situation I had
something in the form's On Current event along the lines of:

If Me.NewRecord Then
Me.TheControlName.DefaultValue = """" & Me.TheControlName.Value & """"
End If

The middle part is, of course, the code Ken provided. I suppose this
is
really more of a question for Ken than a suggestion that is ready to be
tried. As I understand it, you would want to carry the value forward
only
when you are creating a new record.

Thanks. I realize now that I didn't quite understand default value.

"Ken Snell [MVP]" wrote:

An ACCESS form will insert the value from the Default Value property only at
the time of creating the new record. If you later delete the value from that
field, it will remain empty until you put something back into it
deliberately.

--

Ken Snell
MS ACCESS MVP

"BruceM" wrote in message
...
Ah, I see. The If...Then would be necessary only if DefaultValue is
dropped
from the code. DefaultValue is redundant with If Me.NewRecord, or
If...Then
is redundant with DefaultValue. But would DefaultValue apply any time the
field is blank, whether or not it is a new record, or only with a new
record?
I think I remember something from earlier in the thread that the field in
question could be blank.

"Ken Snell [MVP]" wrote:

Your thought about carrying forward the value into new records is what I
had
been understanding... but I'm not sure that this is what G.I.O. actually
wants?

A default value will be put into a record only when a new record is being
created. Thus, it should be unnecessary to use the If...Then test that
you
suggest.

--

Ken Snell
MS ACCESS MVP

"BruceM" wrote in message
...
I've been watching this thread, and am going to pop in for a moment and
hope
that I don't muddy the waters. In a somewhat similar situation I had
something in the form's On Current event along the lines of:

If Me.NewRecord Then
Me.TheControlName.DefaultValue = """" & Me.TheControlName.Value & """"
End If

The middle part is, of course, the code Ken provided. I suppose this
is
really more of a question for Ken than a suggestion that is ready to be
tried. As I understand it, you would want to carry the value forward
only
when you are creating a new record.

Ken:

This is it! This will work for me just fine and dandy.

Thank you!
George

"Ken Snell [MVP]" wrote:


If you want to manually decide when to "copy" the value from one record
into another, use the Keyboard Shortcut key already existing in ACCESS --
namely, Ctrl + '. This will copy down the value from the previous record to
the current record for that field. Will that meet your needs?