Set field to current date if empty

[goslincm]

I want to put some code behind a OnClick event, but I am coming up short.

I have a field on my form called [emailsent]. When a user clicks the button to print a report, I also want it to check if this field has anything in it, IF not, I want current date in it, otherwise, if it already has a date, I want that date to remain as is.

Could someone help me?

Thanks

[GazMathias]

If isNull(Me.TextBoxName.Value) Or Me.TextBoxName.Value = "" Then
  Me.TextBoxName.Value = Date
End If
 
... Code to run report.

In future, could you also post the code that is failing you? That way we can just point out what is wrong instead of writing code for you, and you'll feel a sense of achievement for the code you did get right ;)

Gaz

[goslincm]

If isNull(Me.TextBoxName.Value) Or Me.TextBoxName.Value = "" Then
  Me.TextBoxName.Value = Date
End If
 
... Code to run report.

In future, could you also post the code that is failing you? That way we can just point out what is wrong instead of writing code for you, and you'll feel a sense of achievement for the code you did get right ;)

Gaz

Thanks so much and yes in the future I will submit my code.

[missinglinq]

Also, be aware if you're running a report based on the current record, and the record is new or is an existing record that you've edited (like updating the date field) you need to explicitly save the record before running the report, using something like

If Me.Dirty Then Me.Dirty = False

Linq ;0)>

[NeoPa]

@Gaz
Empty controls should always return Null rather than empty strings. IE. You should always get away with :

If IsNull(Me.TextBoxName) Then

PS. .Value is also the default property so is not generally required. It still works perfectly, but tends to detract from, rather than enhance the readbility.

PPS. I hope you don't feel you're being criticised. I can actually see how much help you're providing so I'm just throwing out some tips.

A very warm welcome to Bytes!

[GazMathias]

@Gaz
Empty controls should always return Null rather than empty strings. IE. You should always get away with :

If IsNull(Me.TextBoxName) Then

No probs mate, I always used to do that, but I have had instances in applications where errors have been thrown out and I found the only way around was to check for a zero length string, I guess because most of the data I work with comes from Sage Line 50 via ODBC. I do that in ASP too, thinking about it (again with the Sage stuff!). A habit hard to break, I would say.

[NeoPa]

That may well make sense Gaz (I play with one ODBC Driver - two if you include MS SQL Server - but its foibles are specific to that particular driver).

Anyway, I see you are now a full member. Congratulations :)

PS. Do I gather from your terminology you're another Brit?