Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
MechMachineMan
in reply to: Anonymous

By using:

 

If iProp.Value is Nothing

 

If iProp.Value = ""

 

If iProp.Value.IsNullOrEmpty

 

 

All 3 of these work by just checking the contents of the String Type Variable and any one would work for this case. If they have writing in them, but its not what you want, you have to compare the format then.

 

Ie; if your part number is supposed to be like 123-4567 we could check for the format usingthe like operator from vb.net (google "vb.net msdn like operator" for more info)

 

iProp.Value Like "###-####"   ' # is a number wildcard; just means it's a digit, - is the symbol itself.

 

Or something simpler like:

 

iProp.Value Like "*-*"    '* is a wildcard when using the like operator; can be any char(number/letter/symbol) and any number of chars

 

(https://msdn.microsoft.com/en-us/library/swf8kaxw.aspx)


--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.

Justin K
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization


iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread

Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects

Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help

Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type