-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Ôóíêöèÿ äëÿ ôîðìàòèðîâàíèÿ ïîëÿ ÌÅÌÎ

Ñðåäà, 14 Ìàÿ 2014 ã. 11:54 + â öèòàòíèê
Çäðàâñòâóéòå!
Óâàæàåìûå ýêñïåðòû ïîìîãèòå, ïîæàëóéñòà, íàïèñàòü ôóíêöèþ, ôîðìàòèðîâàíèÿ ñòðîêè äëÿ ÌÅÌÎ ïîëÿ â Access.
Íåîáõîäèìî, ÷òîáû øðèôò áûë:
Âûäåëåííûå
Ðàçìåð 14 ïò.
Èìÿ "Calibri"

Ñåé÷àñ äëÿ óäàëåíèÿ ôîðìàòà èç ñòðîêè ÿ èñïîëüçóþ ôóíêöèþ
Function DeleteFormat(ByVal z As String) As String
  Dim x As Object, y As Object
  Dim i As Long

  Set x = CreateObject("VBScript.RegExp")
  x.Global = True
  x.Pattern = "<.*?>"
  Set y = x.Execute(z)
  For i = 0 To y.Count - 1
    z = Replace(z, y(i), " ")
  Next
  Do While InStr(z, "  ") > 0
    z = Replace(z, "  ", " ")
  Loop
  DeleteFormat = Trim(z)
End Function
Õîòåëîñü áû, ÷òîáû íîâàÿ ôóíêöèÿ èñïîëüçîâàëà òàêæå îáúåêò CreateObject("VBScript.RegExp").

ß íå ïîíèìàþ êàê ïðàâèëüíî íàïèñàòü øàáëîí è ïðèìåíèòü åãî.

http://www.sql.ru/forum/1094505/funkciya-dlya-formatirovaniya-polya-memo


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó