O'Reilly logo

Microsoft® Access VBA Programming for the Absolute Beginner by Michael Vine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 6COMMON FORMATTING AND CONVERSION FUNCTIONS

So far you have learned to use some built-in VBA functions such as InputBox and MsgBox, which provide interactive dialog boxes to the user. What you might not know is that VBA provides many more intrinsic functions for you to use in your programming efforts. Learning how to leverage the power of these built-in functions is all-important in VBA programming and is certainly the key to saving you from unproductive programming time.

To facilitate your learning of VBA functions, this chapter introduces a number of commonly used functions for formatting strings, dates, time, and for converting data.

STRING-BASED FUNCTIONS

Someone famous once asked, “What’s in a name?” Someone less famous (yours truly) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required