Here's what worked for me to give me a blank form when the form is first loaded:
Private Sub Form_Load()
Me.Form.RecordSource = "SELECT * FROM [qryProdMaster] WHERE PMSiteID = 0"
End Sub
The key in the above RecordSource is the 'PMSiteID = 0'. I have no ID with 0 so it gives me a...
I've had this same problem mainly with controls with date formats. On the right margin, the last number of the date is sometimes partially cutoff. I was able to fix this by simply changing the font. I was using Aptos (Detail) but simply changed to Aptos (Header) which fixed the issue. Arial and...