Colour text in code tags?

[Gasman]

Hi Jon,

Is there anyway to 'show' coloured text within code tags.?

When editing it, it shows Bold, colour etc, but when displayed, nothng.?

Trying to highlight a piece of code easily for a member who is asking for help, otherwise it has to be outside the code tags.

 

[theDBguy]

Sure. Use rich. For example.

bold and red

 

[isladogs]

Or use the SQL language option in the code tags. For example:

'###############################################
#If VBA7 Then 'A2010 or later (32/64-bit)
    Declare PtrSafe Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)     
#Else 'A2007 or earlier
    Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
#End If
'###############################################

Sub Wait(N As Integer)
'creates a delay while other code executes
'N = number of seconds to wait

    Dim i As Integer
    For i = 1 To N
        Sleep 1000              'sleep function from api library file
    Next
    DoEvents
End Sub

Or use Crystal's approach to colour comments green https://www.access-programmers.co.uk/forums/threads/color-comments-green.310752/#post-1685050

 

[Gasman]

Ah OK, thanks both.

I was aware of Crystal's comments DB, but just wanted to highlight portions within a line of code.

 

[Gasman]

Colin,

Just tried SQL and I got this?

 strSQL = "UPDATE tblInventory SET [AmtInStock] = [AmtInStock] [B]+[/B] " & CStr( Me.[Amount] ) & " ;"

I was trying to highlight the + sign in the code in another thread.

I'll experiment with the other types here

 strSQL = "UPDATE tblInventory SET [AmtInStock] = [AmtInStock] + " & CStr( Me.[Amount] ) & " ;"

Cheers theDBGuy, seems Rich Text will do what I was attempting to show.

 

[strive4peace]

hi Gasman ,

Rich BBcode:

[highlight=yellow]the highlight tag doesn't seem to work in rich text code on this forum (yet?)[/highlight]
[BGCOLOR=#FFA]BGCOLOR doesn't work either[/bgcolor]
but you can use bold, underline, and italic
and different colors for the text such as green, red, blue
and combine effects like bold+purple

 

[strive4peace]

ps

you also have to toggle the BB code indicator to show and edit codes OR hide the codes and show effects

 

[Minty]

Although not directly related, I'd much prefer to have the Code option available outside of the drop-down in the editor, I think it's why new members don't use it as it's not obvious.
And a option for vba in the available languages would be brilliant. (Default obvs)

 

[isladogs]

Although not directly related, I'd much prefer to have the Code option available outside of the drop-down in the editor, I think it's why new members don't use it as it's not obvious.
And a option for vba in the available languages would be brilliant. (Default obvs)

Agree with both comments. The code window is more powerful than before but its too hidden away.

 

[Jon]

Having just read this thread, I have tweaked the settings and now you have both code and inline code buttons outside of the Insert dropdown.

 

[strive4peace]

Having just read this thread, I have tweaked the settings and now you have both code and inline code buttons outside of the Insert dropdown.

thank you, Jon!

 

[CJ_London]

@Jon on this subject I have two issues with the code tag

the first is if I type the code in the thread and then decide to surround with code tags (as it used to be) then a) I have to remember to copy it first to paste into the code window and b) when pasted it becomes double spaced. Guess I'll have to change my ways

The second is toggle BB codes - this disables the ribbon - but perhaps I'm missing something?

 

[strive4peace]

@Jon on this subject I have two issues with the code tag

the first is if I type the code in the thread and then decide to surround with code tags (as it used to be) then a) I have to remember to copy it first to paste into the code window and b) when pasted it becomes double spaced. Guess I'll have to change my ways

The second is toggle BB codes - this disables the ribbon - but perhaps I'm missing something?

hi CJ ,
I've noticed this too! ... but anymore, I use my add-in to color comments, even if there aren't any, since I usually have some database in Access open and its quick. It puts tags around the code and doesn't double-space the lines. Download it here:

Color Comments Green
https://www.access-programmers.co.uk/forums/threads/color-comments-green.310752/

 

[Jon]

@Jon on this subject I have two issues with the code tag

the first is if I type the code in the thread and then decide to surround with code tags (as it used to be) then a) I have to remember to copy it first to paste into the code window and b) when pasted it becomes double spaced. Guess I'll have to change my ways

The second is toggle BB codes - this disables the ribbon - but perhaps I'm missing something?

It sounds like there is some kind of text formatting issue. So, perhaps you could strip the formatting of that text once copied to the clipboard. Not sure if this works: https://www.addictivetips.com/windo...from-clipboard-text-with-a-keyboard-shortcut/

Or, have you tried the Inline code thing instead?

To be frank, I have no idea what the BB toggle thing does!

 

[strive4peace]

To be frank, I have no idea what the BB toggle thing does!

it shows the BBcodes instead of the effects, so instead of bold text, you would see the bold tags

 

[Jon]

You answer may lie here somewhere: https://xenforo.com/xf2-docs/manual/bbcode/

 

[strive4peace]

not all work -- first tested div for background color since other tags I tried for changing background for text didn't work either ... but thanks, Jon ... more to explore

 

[strive4peace]

Jon, is there a list somewhere of the rich BBcode tags that AWF supports in the Code=rich tag?

 

[Jon]

I have no idea. You can always try Googling xenforo bbcode tags list.

 

[Minty]

I meant to add that MrExcel has a VBA option in its code tag languages and is run on XenForo2 so it must be possible.