How to Pad Values in Microsoft Access
HTML-код
- Опубликовано: 14 окт 2024
- In this episode we learn how to left-pad or right-pad our values with characters so that special conditions can be met, whether you are filling a fixed-length field, padding employee numbers that lost their leading zeroes, or satisfying other custom field requirements. Padding is something that you'll definitely need as you progress in MS Access development. Let's go!
Block spammers from harassing your Remote Desktop, filling your Windows security logs with failed RDP attempts, and burning up your bandwidth with my BZ RDP Cloaker:
buy.billzone.c...
Check out my easy time entry system for your business:
system.billzon...
Join me on Patreon!
/ mackenziedataengineering
Check out some tech (and support my channel!):
www.amazon.ca/...
Want the code from this video?
mackenziemacken...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a RUclips Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#msaccess #vba
Great, thank you very much, keep it up
Thx!
Hi Sean. Great tip! For left padding, I simply use the Format function. So "Format("123", "00000")" returns "00123". However, I have never needed right padding, so the method you showed will definitely come in handy if I ever need it.
Great tip! That's a good one. I think lots of people also just concatenate the string "00000" or "XXXXX" or whatever, then get Right/Left.
📝
Is it possible to pad with random numbers and unique!!!!
( when I ask for a rise I get left padding increase😢)
I see! That's a great idea - nice idea to use random numbers but that would be another video (cool one). We would look into a random function for that 🛠
Good on you
(Attitude of a MVP)🎬