Expert 11 Lesson 5, T 4:50 ish Access 2016 on Win10
When I run MostRecentContact2Q, my notes fields are blank where they should have text from the ContactT Notes field. Interestingly I get the correct #Error stamps in the correct fields, so it's reading that fields are null or not, and the IIF statement works to change the text, I just cannot find a reason why it wont display. I have triple checked my DLookUPs and expressions for errors. I should say that this is also a fresh database downloaded from lesson 9, it's not one I have played around with, so I can only assume it is something to do with my client settings? Possibly the RichText throwing a spanner in the works? I tried change the format to PlainText though but that didn't work.
I just downloaded the database myself, and it works fine for me. I see you're in the UK. Must be a regional date/time setting issue. This is why I recently switched everything I do to the ISO date format, and will in the future when I re-record these videos. SO many problems. Kevin, what do you get when you download the database file?
Kevin Robertson
@Reply 3 years ago
I'm using ISO as well. Before switching I had lots of problems with the date format.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 11.
