How Add Text in field if case the field is empty

[aftfm]

Hi




How to Make an empty field schedule database ACCESS default text in case the field is empty

Default text like 12345

[June7]

Could use the DefaultValue property. When record is initiated during data entry, the field will already have this value and users can change if they choose.

Or for a report, can calculate the alternate value in query or textbox. Use Nz().

Nz([fieldname], "something here")

[aftfm]

What is the meaning Nz
I Started
Nz([LastStampDate];"1234567890")

But he did delete the empty record puts text 1234567890

[June7]

My example shows a comma, not semi-colon.

You did not ask to delete record.

You asked how to show a default value if field is null. Nz() function serves that purpose.

[aftfm]

Yse I asked how to show a default value if field is null. Nz() function serves that purpose.

But he has deleted the entire record of the table

I Write Nz([LastStampDate];"1234567890")

[June7]

Who is 'he'?

I don't understand the issue. If record is deleted then it's deleted, I can't do anything about that.

[aftfm]

Ok Thanks

This does not prevent, I have benefited from you

[aftfm]

I want her as well in the case of an empty field in the first picture

Like the second picture

[June7]

If you want to actually save the value to new record, options are:

1. set DefaultValue property

2. use code to save the value

If you need to populate this field for already existing records, then run an UPDATE action.

[aftfm]

Is it possible to provide me with this code

[June7]

Which code - option 2?

Code in some event behind form, perhaps form BeforeUpdate:

If IsNull(Me!LastStampDate) Then Me!LastStampDate = "1234567890"

[aftfm]

Well that's where the code bearing

If IsNull(Me!LastStampDate) Then Me!LastStampDate = "1234567890"

[June7]

Don't understand that response.