Search results

  1. D

    Question Strange TextBox Behavior

    I'm using: Microsoft Office Professional 2016 Version 1710 (Build 8625.2139 Click-to-Run) It is possible this odd behavior has always existed, but in the many years I have developed Access applications, I have not noticed it. I have placed a TextBox on a Form. I note this behavior whether the...
  2. D

    Apply anchoring after resizing a control

    Consider please a Form with two controls on it. On the left is any control - say, a TextBox. On the right is another TextBox. LeftTextBox anchoring is Stretch Down. RightTextBox anchoring is Stretch Down and Across. I'd like to show/hide LeftTextBox, the effect being that the control is...
  3. D

    Position cursor after a range

    Having a heck of a time trying to find the answer to what seems like a really simple thing to do: After defining a range of a single point (blinking cursor), I set the range's .Text property to some string. No problem here. I then want to position the cursor at the end of that text. The text...
  4. D

    Cancel listbox selection

    Hi all, this is something I've had trouble understanding, despite years of not understanding it... I have a form with one listbox and one subform control. Listbox contains list of reports. Subform control contains an options form for whichever report is selected in the listbox. None of the...
  5. D

    Create range of duplicates from another range

    Is it possible to create a range consisting of all cells with duplicate values contained in a different range? Conversely, is it possible to remove all non-duplicated cells from a range? I foolishly posed this question at the tail end of a post regarding another matter, so I'm creating a new...
  6. D

    Create Range Using External Criteria

    I'd like to create a range of cells using criteria as follows: Include all Cells in Column B where any Cell in Column A whose Value is "Test" Someone please help...this is driving me nuts. Edit: I am using Excel 2003. Many thanks.
Back
Top Bottom