Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by Seamus2626
at 2024-07-25 07:39:41
ModifyPoint:500 Replies:5 POST_ID:829103USER_ID:11690
Topic:
Microsoft Excel Spreadsheet Software;;Microsoft Access Database
Hi,
Im trying to line up indentations in my modules, when i highlight the code and attempt to edit using Format>Horizontal Spacing, the option to do so is greyed out
I have attached a screenshot
I have stepped in and out of the code but the problem still remain, has anyone a solution?
Thanks
Im trying to line up indentations in my modules, when i highlight the code and attempt to edit using Format>Horizontal Spacing, the option to do so is greyed out
I have attached a screenshot
I have stepped in and out of the code but the problem still remain, has anyone a solution?
Thanks
Assisted Solution
Expert: Rey Obrero (Microsoft Access MVP) replied at 2024-07-25 08:13:03
100 points EXCELLENT
you can use the "Indent" and "Outdent" from the Edit menu
Assisted Solution
Expert: Scott McDaniel (Microsoft Access MVP - EE MVE ) replied at 2024-07-25 08:12:14
100 points EXCELLENT
If all you're trying to do is indent, you might try Smart Indenter:
http://www.oaltd.co.uk/Indenter/Default.htm
It's free, and I've used it in every version of Access from 2003 - 2013.
If you need more power, you might consider FMS CodeTools:
http://www.fmsinc.com/MicrosoftAccess/VBACodingTools.html
Total Visual Code Tools is very powerful, with tons of features. I use it every day in my Access work and would be very hard pressed to work in Access VBA without it.
http://www.oaltd.co.uk/Indenter/Default.htm
It's free, and I've used it in every version of Access from 2003 - 2013.
If you need more power, you might consider FMS CodeTools:
http://www.fmsinc.com/MicrosoftAccess/VBACodingTools.html
Total Visual Code Tools is very powerful, with tons of features. I use it every day in my Access work and would be very hard pressed to work in Access VBA without it.
Assisted Solution
Expert: Helen_Feddema replied at 2024-07-25 08:07:34
100 points EXCELLENT
There is no Format menu in the VB window (if we are talking about Access here). The indentation is determined by the setting in the Options dialog, opened from the Tools menu in the VB window:
It is the same in the Excel VB window.
If your code has irregular indentations, you have to fix them manually. The setting in the Options dialog only applies to future indents.
Assisted Solution
Expert: Rob Henson replied at 2024-07-25 07:53:44
100 points EXCELLENT
I believe the Format menu is only for use with Drawn objects such as buttons on User Forms.
Thanks
Rob H
Thanks
Rob H
Accepted Solution
Expert: duncanb7 replied at 2024-07-25 07:43:56
100 points EXCELLENT
where screenshot ?
Duncan
Duncan
