Discussion Locked
0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a date of birth field with a date/time format. Would it be possible to enter "U" for "Unknown" in here as well?
5 replies
by sl-campbell
No, not on a date field. Just leave it empty or assign it to a NULL (field =Null). That should identify that there is no date or it is unknown.
by sej
Poster rated this answer
by john_wills
I can go one step better than SLCampbell. Write an expression for the control:
=IIF(isnull(DateOfBirth),"U",DateOfBirth). You write this in the expression box found by clicking on the property "control source" under the "Data" tab of the property box for the control.
This way the item in the table is null but appears as "U" on the form.
by sej
Poster rated this answer
by sej
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
0 helpful
1 reply
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies