<div>
Two distinct fields my friend! <br />
<br />
Thank you very much :)
</div>


Two distinct fields my friend!

Thank you very much :)

<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
What is the correct formatting for this control source?<br />
<br />
=&quot;Date: &quot;&nbsp;&amp; [Date] &amp;&nbsp;&quot; Time: &quot;&nbsp;&amp; [Time]<br />
<br />
I want to add formatting so the date is dd/mm/yyyy &amp;&nbsp;the time is hh:mm:ss <br />
<br />
At the moment the current control source returns<br />
<br />
Date: dd/mm/yyyy hh:mm:ss &amp;&nbsp;Time: dd/mm/yyyy hh:mm<br />
<br />
Thanks<br />
<br />
Chris
</div>
</div>


Hi there,

What is the correct formatting for this control source?

="Date: " & [Date] & " Time: " & [Time]

I want to add formatting so the date is dd/mm/yyyy & the time is hh:mm:ss 

At the moment the current control source returns

Date: dd/mm/yyyy hh:mm:ss & Time: dd/mm/yyyy hh:mm

Thanks

Chris

Correct formatting for this control source?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.