Search results

The thing is, only a Variant can contain Null. Also, for this reason, Null propagation by use of the + operator wouldn't occur were a string variable to be concatenated similarly. If the string variable were uninitialized or expressly set to "" (i.e., a zero-length string) or vbNullString...

I'm not certain that Null is a constant but leaving that aside, I think George was on to something by suggesting this behavior is the consequence of an evaluation. Delimiters trigger evaluation in VBA and Windows, and in Bash, for that matter. Octothorpes trigger evaluation of date literals in...

Very good questions, actually. I was just framing out two or three generic upstream helper functions to do some small things (mostly relating to delimitation) to facilitate dynamic construction of SQL statements and criteria expressions when the behavior manifested. I've exploited other...

Len() (and LenB()) are two tests I hadn't attempted. I tried them just now and both return Null, which one would expect for a Null input but not for a string. This said, I tried a number of other things all related to evaluation or type conversion in one form or another, so you may be onto...

Actually, I've been tinkering further and this (inconsistent output to memory and the Immediate window) seems exactly to be what is occurring. I tested a variety of means to obtain or assign the string output, without success. Given the input I described, the VBE, as compiler / command...

George, this illustrates and confirms the behavior of my "TestTheTest" function, which is that the return both evaluates as Null and prints the string.

I've been tinkering a bit. If concatenated with &, Null returns; if concatenated with +, "Null" returns. Expanding the original function a bit and adding a test function (with the Immediate pane output commented by line) illustrates my observation. What's interesting is that the test function...

Perhaps this is new, or just new to me, but I just learned that a string that concatenates a Null Variant variable between octothorpes using Null propagation (by use of the + operator) does not return Null but rather the string "Null" (without the quotation marks). This can be handy but I just...

Well, that's the question, really: Does a technique exist besides the obvious, of tinkering with coordinates and dimensions. Regarding controls, the anchor properties are all that are necessary here. Really, only the memo control need resize with the form and it already does. I would add it...

Colin, thanks. This is just the direction I'm headed, especially after George's and @MajP 's input. Simply because, to me, the additional window sizing options afforded in Windows 7 (I believe) by pressing Win or Win + Shift and an arrow key (maximize vertically, maximize horizontally, anchor...

LOL. Actually, the specific context is PopUp forms in single form view having a text box bound to a memo field. An unbound example would be a custom Zoom form, the chief purpose of which is to get more real estate for a memo-bound control. A bound example might be a data entry form, needing...

Yes, I neglected to mention that technique, but in the end it is simply another manner of setting Form.Top and Form.WindowHeight (and the method's other two parameters and the corresponding form properties), which I mentioned.

The thread title. Is there a way to maximize a form, meaning a PopUp form in my case but perhaps also a form if in overlapping forms mode, vertically? Put otherwise, is there a way to get or set this window state for such a form? By "vertically," I mean vertically-only, retaining the form's...

I haven't done a study, per se, but it is fairly easy. This nuance isn't something that most people would expect. Null handling is a bit arcane for beginners and it may not occur to them to think what the test is for whether "Required" is met. This is true. My statement was overly broad...

A default value differs from a blank value, to be clear. A default value follows from what's expressed in the field's DefaultValue property. Delete the "0" for numeric fields and the field will be Null for new records. AllowZLS doesn't set the default value of text fields to "", it just says...

I actually had been thinking along these lines and by experimenting with adding a null record to the lookup table. Alas, no dice. Agreed that 0 as default for numeric fields is inappropriate. I've gotten stung on this with FK fields a few times. Deleting the "0" from the field's DefaultValue...

Good thoughts and questions. Initially, this is more the "Loan Type" scenario you describe. Furthermore, the main table has no records at all. So, this isn't a question of it having records with FK values not matching those in the lookup table. Its FK field has AllowZLS = No, so that field...

That's true, of course, and is the case. No reason for the problem, even still. What ended up working was deleting the relationship another table had with the lookup table. I have no end of tables sharing a lookup table in other contexts, so this explains nothing. Re-creating this second...

I actually did say, actually: The main table has no records. So, any and every record will start with a null FK value because AllowZLS = No.

This is a new one. I'm encountering the error "You cannot add or change a record because a related record is required in table [X]". The first question is why would this be? In my experience, FK field values are optional, so this comes as a bit of a surprise. The second question is what can...