Hi
How to Make an empty field schedule database ACCESS default text in case the field is empty
Default text like 12345
Hi
How to Make an empty field schedule database ACCESS default text in case the field is empty
Default text like 12345
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")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
What is the meaning Nz
I Started
Nz([LastStampDate];"1234567890")
But he did delete the empty record puts text 1234567890
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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")
Who is 'he'?
I don't understand the issue. If record is deleted then it's deleted, I can't do anything about that.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Ok Thanks
This does not prevent, I have benefited from you
I want her as well in the case of an empty field in the first picture
Like the second picture
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Is it possible to provide me with this code
Which code - option 2?
Code in some event behind form, perhaps form BeforeUpdate:
If IsNull(Me!LastStampDate) Then Me!LastStampDate = "1234567890"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Well that's where the code bearing
If IsNull(Me!LastStampDate) Then Me!LastStampDate = "1234567890"
Don't understand that response.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.