I'm just creating my first report in Access 2013 and don't have a clue what "#Size!" displayed in the text box "tbCatTotal" means. The test code looks like this where the control source for the text box is "=CatTotal()".
A snippet of screenshot:Code:Option Compare Database Dim CatAmt As Currency Private Sub Report_Open(Cancel As Integer) Me.imIcon.Picture = DLookup("[IconFile]", "tblsettings") CatAmt = 10 End Sub Public Function CatTotal() Me.tbCatTotal = CatAmt End Function