Recent content by ross6655

Good morning. I've found the problem in the form, but I'm not exactly sure how to fix it. I was getting a Circular Reference error when trying to apply Format to the date text box in the form. This is because the text box has the same name ("Maturity Date") as the table's field which it pulls...

Thank you! This worked perfect on the reports, I changed my regional settings back to default to make sure. I couldn’t get it to work on the form, however. The form’s record source is the table itself, while the reports’ record source is a query. Some of the dates on the form are blank, so I...

Thanks for the response. That’s strange you got it to work with presumably the same regional settings. I’ll post my control source later tonight or tomorrow morning. It’s an if statement that sets the date field = Null if another field equals “cash”, and otherwise sets it equal to the date in...

This did it! Thank you so much - and to whoever suggested that. I'll have to apply the change to the users' who are frequently in the database as they are the ones who generate the reports. But if it worked on my machine, I see no reason why it wouldn't on theirs. (Well, I won't say no reason...

Yes that's correct on how the date is returning. I know it sounds counterproductive to display 10/07/50, but I only want it displayed like this in the report that is sent off to clients monthly. I would cringe to see it stored like that in the table. And yes, the date column in the table is...

Thanks! Here's a screenshot of how the dates look in the report. The ones before 2050 look right, but 2050 and later they default to the 4 digit year. And also of the report property sheet for the field in question, maturity date. It is the same in the form.

Hi everyone, This is my first post here, I've recently started working as a developer and part of my job is managing the countless databases my company has. This has been a great resource, but I'm stuck on a date format issue and can't find an answer by searching. The issue I'm having is...