Here Is An Example Of The VBA Trim Function
The “Trim” function is useful in eliminating the blank spaces in a string normally caused by some data entry error. Why do you want to do this? Well because a sorting error can happen if you are trying to sort ” Dan, “Fred”, and “Ann”. ” Dan” will show up on top before “Ann” because […]
Here Is A Customized Msgbox VBA Example
Here is an example of a customized VBA Msgbox. We giving some richtext and customizable flair to the rather ordinary message box. The following code provided with the code after the screenshot, is going to provide you with the ability to really make the ordinary message box shine! Sub MsgboxVBAExamples() Dialog.Box “VBAHowTo.com is your source […]
How To Return A Dollar Value As A Text String
Hi, I received an interesting request, involving VBA and how to return a stock price dollar value in a text character string rather that actual numbers. Like (I=1,M=2,E=0) instead of showing cost price is 12.00 it shows IM.EE. Kind of like code returning a special code. Well, here is my rendition of it. It may […]
MS ACCESS FORM VALIDATION – PT4
In this video we will cover VBA validation functions like: Validating Text Strings Check the string for null values. IsNull function Check the length of a string. Len Function Check the presence of characters present in a string. InStr function Inpect a portion of a string. Left, Right, Mid functions Removing the leading or trailing […]