How to replace all instances of '/' in a string function?

[Josha]

So in my Access database I have two fields for my science students ;

Field #1: contains the students case number. The field is called [CaseNumber]
Field #2: contains the students examination date. The field is called [ExaminationDate]

In a separate unbound field on the form called [ReportName] the Control Source has the following :

=[CaseNumber] & [ExaminationDate] & "Notes"

So if the case number was 1234/2022 and the date was 2022.02.10 then the [ReportName] will automatically display : 1234/2022 2022.02.10 Notes.

Which is fantastic ! However, I want the [ReportName] field to replace any instance of "/" (forward slash) to a "-" (dash)...... So that the [ReportName] field would auto display 1234-2022 2022.02.10 Notes.

Is there a way I can do this? With a replace function? in VBA maybe? I don't know?

Thanks!

[June7]

Yes, use Replace() function.

If you don't want to actually change the saved data, just calculate in query or textbox. And you probably need to Format date. Don't forget separating spaces.

Replace([CaseNumber], "/", "-") & " " & Format([ExaminationDate], "yyyy.mm.dd") & " Notes"

[Josha]

That was so simple! It worked !

Thank you for your reply