Access DB Size as part of MsgBox?

[MikeL]

Hello,

As part of VBA, I would like to determine size of database after running some lines of code and put results om Msgbox. Any ideas?

I did find this UDF on the Web. Dont know if it works or how to incorporate.

Function GetFileSize() As Long
GetFileSize = FileLen(CurrentDb.Name)
End Function

Thanks in advance

 

[JonXL]

You can call that function in your MsgBox with

MsgBox GetFileSize

This will also let you determine if that function does what you want it to do (I don't know if it does).

 

[MikeL]

You can call that function in your MsgBox with

MsgBox GetFileSize

This will also let you determine if that function does what you want it to do (I don't know if it does).

thanks, I used that approach and tranlated size to Gb